Integration Layer data object creation templates

These templates create the physical table structures for the Integration Layer of a Data Vault. They are assigned to Data Objects representing Hubs, Links, and Satellites, and produce the DDL needed to deploy those objects to SQL Server.

For the mapping templates that load these tables (or expose them as views), see the integration mapping templates.

Templates in this section

• Hub SQL Server table — Generates the physical Hub table with primary key, business-key clustered index, and standard Data Vault audit columns.
• Link SQL Server table — Generates the physical Link table with a non-clustered primary key on the link hash key and a clustered index on the reference keys.
• Satellite SQL Server table — Generates the physical Satellite table with a clustered primary key on the surrogate key and effective-date columns.