tasks, or taskflows, you can either create the asset from scratch or use a template.
offers a variety of data manipulation templates to jump-start your project. Templates include pre-built logic that you can use for data integration, cleansing, and warehousing tasks.
To help you create assets quickly,
provides the following types of templates:
Mapping templates are mappings in which the transformation logic and required parameters are defined for you.
provides mapping templates for integrating data, cleansing data, and loading slowly changing dimension tables. For example, the
Merge two data sources
mapping template is a mapping that merges two sources so that if a field in one source is empty, the value from the other source is used.
Create a mapping from a template when you want to reuse the logic in one of the template mappings, but you also want to customize the mapping to meet your needs. When you finish the mapping, create a
task to run it.
For example, you want to merge two sources so that if a field in one source is empty, the value from the other source is used. However, you also need to sort the data before loading it to the target. Create a mapping based on the
Merge two data sources
mapping template, and add a Sorter transformation to sort the data before loading it to the target. Then, create a
task to run the mapping.
task templates are
tasks that are based on the template mappings. Use a
task template when you want to run one of the template mappings without changing the transformation logic. When you create the
task, you only need to supply the runtime information such as the runtime environment, source and target information, and values for other mapping parameters.
For example, you want to augment data from a relational source with additional fields from a reference table. Create a
task based on the
Augment Data with Lookup
template. In the
task wizard, enter the runtime information such as the runtime environment, source table, target table, lookup table, and lookup condition.
Taskflow templates are taskflows that contain common control flow logic.
Use taskflow templates to organize tasks in common ways such as sequentially, in parallel, or based on a decision. When you create a taskflow based on a template, the flow is pre-defined. Add and remove tasks to reflect the actual task flow.