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 the Configuration Database.
  • Each Hub Table is created with a Unique Clustered Index , indexed on the Incrementing Hub Key.
  • Each Hub Table is given a Unique Index, indexed on the Business Key or Keys.
  • By Default, this process will fail if the Hub Table already exists.
  • Optionally, the Hub Table can be recreated.

[add link to test cases for these features]

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