Logical Modeling

Overview
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
Conformed Hierarchies
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
Temporal scenarios
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
Multiple arcs option
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
Project options
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
Hide/Show commands
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
Recursion option
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
Allow nulls option
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
Cross Dimensional attributes options
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
Shared Hierarchies options
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