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.