Use a mapping task template to run a mapping task without creating a mapping beforehand.
Each mapping task template is based upon a mapping template. Use a mapping task template when the mapping on which the mapping task template is based suits your needs. When you select a mapping task template, Data Integration creates a copy of the template for you to use. When you define the mapping task in the task wizard, you save a copy of the mapping template on which the mapping task template is based.
Available templates are divided into categories on the Templates page. You can also view all templates, filter and sort the page, or search for a specific template.
The following image shows the Templates page with the All templates tab open:
The templates range from simple templates that you can use to copy data from one source to another, to complex templates that you can use for data warehousing-related tasks. Drill down on a template to view more information about it, including the mapping image.
Data Vault templates
Use a Data Vault template to create a mapping task 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.
