Raw Vault Layer – Create Link Table

Create or Recreate a Link Table. Process: {Configuration Database}.[dbo].[dv_create_link_table] Features: Using information from the Configuration Database, instantiates a Link Table. The Technical Columns and Naming Standards are derived from the Default...

Raw Vault Layer – Create Hub Table

Create or Recreate a Hub Table. Process: {Configuration Database}.[dbo].[dv_create_hub_table] Features: Using information from the Configuration Database, instantiates a Hub Table. The Technical Columns and Naming Standards are derived from the Default Tables in...

Raw Vault Layer – Load Source Table

Load data, from a Time Variant table, into a Link. Process: {Configuration Database}.[dbo].[dv_load_source_table] Features: Orchestrates the loading of a Time Variant Table into Hub, Link and Satellite Structures. The Configuration Database is used to...

Raw Vault Layer – Load Link

Load data, from a Time Variant table, into a Link. Process: {Configuration Database}.[dbo].[dv_load_link_table] Features: Data is loaded, from a Time Variant table, into the Link. The Load process will create all missing Link entries, for new...

Raw Vault Layer – Load Hub

Load data, from a Time Variant table, into a Hub Table. Process: {Configuration Database}.[dbo].[dv_load_hub_table] Features: Data is loaded, from a Time Variant table, into the Hub. The Load process will create all missing Hub entries, for new...

Raw Vault Layer – Load Satellite(s)

Load data, from a Time Variant table, into one or more Satellites. Process: {Configuration Database}.[dbo].[dv_load_sats_for_source_table] Features: Data is loaded, from a Time Variant table, into the Satellite. For modelling and efficiency...