Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery

Mappings

Mappings

Data Vault templates

Data Vault templates

Use a Data Vault template to create a mapping that writes data to a hub, link, or satellite table.
The Data Vault category contains the following templates:
  • Data Vault – Hub. Generates unique business keys and writes them to a hub table along with the date the records are loaded.
  • Data Vault – Link. Creates relationships between hub or other link tables based on business keys and stores the connection in a link table.
  • Data Vault – Satellite. Generates a satellite table to store descriptive data such as context or history for either a hub or a link.
You can use the templates individually or use all three to help you structure your data. However, Data Vault components must be loaded sequentially. A link record must reference existing hub or link records, and a satellite record must reference its parent hub or link record.

0 COMMENTS

We’d like to hear from you!