Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Data Type Conversion

Data Type Conversion

A Python transformation converts Developer tool data types to Python data types, based on the Python transformation port type.
When a Python transformation reads input rows, it converts input port data types to Python data types. When a Python transformation writes output rows, it converts Python data types to output port data types.
For example, the following processing occurs for an input port with the double data type in a Python transformation:
  • The Python transformation converts the double data type in the input port to the Python float data type.
  • The transformation uses the value in the input port as the value for the Python float data type.
  • To generate the output row, the Python transformation converts the Python float data type to the double data type.
The following table shows how the Python transformation maps Developer tool data types to Python data types:
Developer Tool Data Type
Python Data Type
Integer
Int
Decimal
Float
Double
Float
Timestamp
Datetime
String
Str
The Python transformation does not support data types that are not listed in this table.
Support for binary ports in the Python transformation is deferred. Support will be reinstated in a future release.
When you write code in the Python transformation, the data types of the output ports in the Python transformation must be compatible with the data types in the Python code. Thus, if you configure an output port in the Python transformation to be a double data type, the corresponding variable in the Python code must be a float.


Updated September 28, 2020