Create or Recreate a Satellite Table.

Process: {Configuration Database}.[dbo].[dv_create_satellite_table]

Features:

  • Using information from the Configuration Database, instantiates a Satellite Table.
  • The Technical Columns and Naming Standards are derived from the Default Tables in the Configuration Database.
  • Each Satellite Table is created with a Unique Clustered Index , indexed on the Incrementing Satellite Key.
  • Each Satellite Table is given a Unique Index, indexed on the Hub or Link Key plus the Row Start Date.
  • By Default, this process will fail if the Satellite Table already exists.
  • Optionally, the Satellite Table can be recreated.

[add link to test cases for these features]

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