Integration mapping templates

These templates are assigned to Data Object Mappings whose target is an Integration-Layer Data Vault object (Hub, Link, or Satellite). They come in two flavours:

• View templates — Represent the Integration Layer virtually, on top of the Persistent Staging Area. Use for rapid prototyping or a virtual data warehouse.
• Stored-procedure templates — Materialise the Integration Layer as physical tables, loaded incrementally via a control framework. Use for a physical data warehouse deployment.

For the table-creation templates that build the Hub/Link/Satellite tables (when using the stored-procedure load), see Integration data object templates.

View templates (virtual data warehouse)

• Data Vault Hub View
• Data Vault Link View
• Data Vault Satellite View
• Data Vault Link Satellite View
• Data Vault Link Satellite (Driving Key) View

Stored-procedure templates (physical data warehouse)

• Data Vault Hub Stored Procedure
• Data Vault Link Stored Procedure
• Data Vault Satellite Stored Procedure
• Data Vault Link Satellite Stored Procedure
• Data Vault Link Satellite (Driving Key) Stored Procedure