The incoming value is converted using the following area setting changes. At each stage, the updated value is fed into the next stage. In some cases, not all of the changes appear for every data type.
1. Change the case to upper/lower/proper etc (For more information on how casing affects Data transformations, see this Knowledgebase article.)
2. Transform the values according to matching patterns
a) Matches exactly
b) Matches any
c) Matches word
d) Catch All
3. Transform a dynamic date i.e. add or subtract a number of days/months or years from the current date.
4. Transform a dynamic date i.e. add or subtract a number of days/months or years from the date in the source
5. Transform date format
6. Transform amount by a percentage
7. Transform amount by a fixed amount
8. Determine whether or not a field should be added based on the value of another field. (That field may or may not have undergone a transformation at this point)