Unterfeldstrasse 18, 8050 Zurich
+41 32 511 27 89

Change data capture: delta and full loads into staging – cdc into the core

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