Best practices
Follow our best practices when starting a new project
Modeling Approaches
Use Cases
- Use Linked Projects
- Configure an incremental load
- Configure a multi-version load
- Configure delete detection
- Test a Generator upgrade
- Update a Project when the source changed
- Delta deployment
- Do a partial deployment
- Deploy a Project in production
- Take care of entries from the Data Quality rules log
- Reduce the volume of the Data Quality rules log
- Take care of entries from Cleansing Error tables
- Reduce the volume of the Cleansing Error tables
- Avoid to load all data in development
- Optimize load performance
- Create a Date dimension
- Use parent-child relationships
Business Rules
- Dataflow Sets amount (Business Rule)
- Dataflows amount (Business Rule)
- Relationships amount (Business Rule)
- Supported Term Mappings (Business Rule)
- Identity Terms amount (Business Rule)
- Identity Terms not nullable (Business Rule)
- Supported Implementation Types (Business Rule)
- Implementation Type Dataflows amount (Business Rule)
- Implementation Type Incremental Filter (Business Rule)
- Supported Deduplication Methods (Business Rule)
- Supported Load Cachings (Business Rule)
- Relationships from Link (Business Rule)
- Relationships from PIT (Business Rule)
- Foreign Key Mapping (Business Rule)
- Historized Source (Business Rule)
- ValidFromSourceTerm exists (Business Rule)
- Version Valid From Term configured (Business Rule)
- Fact Load Strategy selected (Business Rule)
- One Fact Load Strategy selected (Business Rule)
- Effective Timestamp mapped (Business Rule)
- Business Key Terms not nullable (Business Rule)
- Business Key Terms amount (Business Rule)
- Supported Aggregation Types (Business Rule)
- Supported Historization Types (Business Rule)
- Supported Term Data Types (Business Rule)
- Terms amount (Business Rule)
- Dataflow Set Model Objects amount (Business Rule)
- Dataflow Sets Aggregation Amount (Business Rule)
- Supported Fact Load Strategies (Business Rule)
- Fact Load Strategy Insert needs Incremental selected (Business Rule)
- Dataflows amount with multi-version load (Business Rule)
- Supported Missing BK Behavior (Business Rule)
- Dataflow Sets amount with multi-version load (Business Rule)
- Deduplication with multi-version load (Business Rule)
- Aggregation with multi-version load (Business Rule)
- Supported Implementation Types for stage-driven load plans (Business Rule)
- No incremental load with a Deduplication (Business Rule)
- No deduplication for Stage objects (Business Rule)
- No Cyclic Dataflow (Business Rule)
- No Cyclic Relation (Business Rule)
- No delete detection with multi-version load (Business Rule)
- No delete detection source with a deleted set (Business Rule)
- Delete detection source exists (Business Rule)
- Delete detection source name is unique (Business Rule)
- Delete detection source Business Key exists (Business Rule)
- No delete detection with an incremental load in the source (Business Rule)
- Delete detection without historization set in the terms (Business Rule)
- Fact Load Strategy Dataflows amount (Business Rule)
- Model object has problematic characters in name (Business Rule)
- Model object has term with problematic characters in name (Business Rule)
- Partition deduplication without business keys (Business Rule)
- Model object has delta detection ColumnComparison and load caching Hashing defined (Business Rule)
- Data quality rules after load (Business Rule)
- Invalid data type configuration (Business Rule)
- Model object type not supported on Fabric Warehouse (Business Rule)
- Composite model object from another layer (Business Rule)
- Setting ignored for a Virtual model object (Business Rule)
- PartialSet delete detection settings (Business Rule)
- Error when parsing template script (Business Rule)
- Cached Mart Dimension referenced by other model objects (Business Rule)
- Valid from timestamp mapped without effect (Business Rule)
- Mixed historization types (Business Rule)
- Historization without result views or persisted validity (Business Rule)
- Target object name conflict (Business Rule)
- Excluded from Delta Detection settings (Business Rule)
- Current View and History View sources (Business Rule)
- Effectivity end mapped while calculated (Business Rule)
- Data quality rules on Data Vault relationships (Business Rule)
- PIT joined with INNER JOIN (Business Rule)
- Snowflake - Use Stream and incremental load settings (Business Rule)
- Optimization Method without columns or with parallel dataflows (Business Rule)
- Microsoft SQL Server - Index definitions (Business Rule)
- Business key data type not usable in constraints (Business Rule)
- Oracle - Index definitions (Business Rule)
- Oracle - Parallel degree and hash group size values (Business Rule)
- dbt incremental read filter not applied (Business Rule)