Scripting transformations

Overview

Scripting transformations are code transformations executed at the different steps in the ETL process, such as before extract/load, for each row, after extract row, etc.

The typical use cases are:

• Change a data set on the fly, including fields, values, and structure.
• Programmatically set global and flow variables.
• Modify source query.

You can use JavaScipt (default) or Python in the scripting transformation.

Create a transformation

To configure one of the following scripting transformations, go to the:

• Transformation/ MAPPING/ Additional Transformations/ Before Prepare Source Query:  Scripting transformation executed before the source query is merged with the Flow variables.
• Transformation/ MAPPING/ Additional Transformations/  Before Extract: Scripting transformation executed before extract.
• Transformation/ MAPPING/ Additional Transformations/ For each row: Scripting transformation executed for each extracted row. The alternative to the scripting transformation For each row is per-field Mapping.
• Transformation/ MAPPING/ Additional Transformations/  After Extract: Scripting transformation executed after extract.
• Transformation/ MAPPING/ Additional Transformations/  After Load: Scripting transformation executed after load.

Read more about the Scripting transformations.