Change data capture: delta and full loads into staging – cdc into the core
The Datavault Builder is automating every aspect of your Data Warehouse. For this purpose it lets you stage all data or a selected subset for your source systems. Additionally it calculates automatically a SCD type 2 CDC while loading the satellites and linksatellites.
- Define delta parameters per staging table
- Define in the job schedule if you plan to full or delta load
- Rely on the automatic CDC calculation while loading the core warehouse
- Immediatelly access as-of-now and as-of-then views on your loaded data
Define delta filters per source table
Automatic CDC into the core using SCD Type 2 historization
Out of the box As-Of-Then and As-Of-Now Views