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

These steps describe how you can use transformation rules when in the mapping editor.

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

The transformation rule that you apply in the mapping specification becomes an annotation in the IBM® InfoSphere® DataStage®job. That annotation can then be replaced by some application logic that is provided by the job developer.

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.