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 keys which have arrived through the Time Variant table.
  • The Server Clock is used to record the arrival Time of each Entry.
  • Only one entry is created for each Business Key.
  • Hubs may be processed independently, but are normally orchestrated to precede a Satellite Load.

Testing the Raw Vault Hub Load

[add link to How to add a new Hub to the Raw Vault]