Generators Release - 2.0.0 (documentation in progress)

General features

• Delta Detection configurable on Model Object instead on Project - where applicable

• Default Indices and constraints added (Foreign key constraints can be enforced on MSSQL and Oracle

• Configurable Custom Indices

• Configurable DataQuality Checks for all Generators

• SCD2 as default for Historization (where applicable)

• Enhanced scripts for deployment

• Loadplan & partial deployment for Datapipe views

• Enhanced modeling support (Validation & Error detection)

• Option to enable/disable drop tables for deployment

• Enhancements DataLoad and deployment (e.g. Snowflake enable/disable drop schema for Load control, check for running tasks before deployment)

• Usage of generated Singleton in all cases (change in behavior of foreign key calculation)

Data Vault

• Record Tracking Satellites with deletion tracking

• Hierarchy Flatten Model Object for additional technologies

• Effectivity Satellites with option to calculate EffectivityEnd Date

• Link Driving Key enhancements

Datamart

• Mart Dimensions with option to configure LoadCaching

• Hierarchy Flatten Model Object for additional technologies

New Generators

• Oracle (no dimensional generator as of yet)

• Fabric Warehouse (no dimensional generator as of yet)

• Snowflake Datastore