Adds a data transformation for each matched attribute to each matched entity.
Label | Description |
---|---|
Match for Attribute | Select the criteria for finding the matching attribute from the drop-down list. Refer to Model Conversion Matching Criteria for details. |
Match source set | Select the matching source set name using a template. The following variable is available:
|
Data transformation name | The name of the data transformation. Note Can use the variables %schema%, %table%, %table_label% and %column%. |
Description | The description of the data transformation. |
Use template | Indicates if the change and condition fields should be interpreted by the template engine. |
Change | The transformation for the data transformation. e.g. UPPER(%column%) Note The following variables are available when Use template is selected:
|
Condition | Similar to the change field, but for the condition of the data transformation. e.g. %column% IS NOT NULL Note The following variables are available when Use template is selected:
|