Applying transformation rules
You can establish and apply transformation rules to a mapping. These rules describe your data transformation requirements to the developers who will prepare the job.
About this task
Procedure
- In the Mapping Editor, go to the column where you want to apply the transformation rule.
- Select the Rule Description cell under the Transformation header.
- Type text in the Rule Description cell that describes the transformation requirements for the data in the source column. You can enter free-form sentences and phrases that require no special syntax.
- Click Save.
Results
Example
The following transformation rule is an example of free-form
text that describes what a data transformation a business analyst
wants when the job is generated:
Aggregate account balance over savings and checking accounts by customer id
to compute the total account balance for each customer.