Select the Variable to fields option if your script is intended to produce its output in the form of individual variables, each of which contains a built-in type, such numerics, strings, and Booleans. This option will map the Python variables and their data types to PDI fields and their data types when running the transformation.
These are the fields in the Mapping table. Select the Get fields button to populate the table with fields from the output step(s) in your transformation.
Note: The Get fields button will execute your Python script using
random input values to determine the output variables. If your script is long running, or
has fixed data requirements, consider manually entering the output variable mapping.
| Option | Description |
|---|---|
| Variable | The name of the Python variable that will be mapped to a PDI field. |
| Python data type | The value of the data type of the variable. For detailed information on data types, see Mapping data types from Python to PDI. |
| PDI field | The value of the PDI field to which you want to map the Python variable. |
| PDI data type | The value of the data type assigned to the PDI field, such as a date, a number, or a timestamp. |