Logical Modeling
Conceptual modeling is the key to build a better data platform: communication between business users and technical people has never been so easy. Sta...
Fri, 8 Mar, 2024 at 12:35 PM
A great feature of indyco, is about the opportunity to manage Conformed hierarchies that you can easily import in your fact schema. Using the Default pr...
Fri, 8 Mar, 2024 at 12:34 PM
When
it comes to dynamic hierarchies and slowly-changing dimensions, three Temporal Scenarios (Up-to-date, Historical, Rollback) are supported
by the DFM an...
Fri, 8 Mar, 2024 at 12:35 PM
A Multiple Arcs can be modeled choosing one of these options: bridge table without surrogates bridge table with surrogates bridge table with surroga...
Fri, 8 Mar, 2024 at 12:35 PM
Indyco enables to configure some categories of options for the logical modeling in order to customize your SQL DDL. From Tools --> Project options, y...
Fri, 8 Mar, 2024 at 12:36 PM
Indyco Builder has some features that allow designers to choose what portion of diagram has to been shown/hidden. Each attribute can have attributes from h...
Thu, 1 Jul, 2021 at 1:06 PM
Recursive Arcs can be modeled choosing one of those strategy. Use self-referencing keys Use navigation table Use self referencing key...
Fri, 8 Mar, 2024 at 12:36 PM
When indyco generates the SQL DDL script gives the opportunity to export or not some sql constraints, in particular primary key and foreign key. Startin...
Fri, 8 Mar, 2024 at 12:36 PM
A Cross Dimensional attribute can be modeled choosing one the following options: Bridge table with surrogates Brigde table without surrogates ...
Fri, 8 Mar, 2024 at 12:36 PM
A Shared Hierarchy can be modeled choosing one of these options: Snowflake Do not snowflake Snowflake option The shared attribute will be mod...
Fri, 8 Mar, 2024 at 12:36 PM