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

Flat File and Transformation Data Types

Flat File and Transformation Data Types

Flat file data types map to transformation data types that the
Data
Integration Service uses to move data across platforms.
The following table compares flat file data types to transformation data types:
Flat File
Data type
Transformation Data type
Range
Bigint
Bigint
Precision of 19 digits, scale of 0
Datetime
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Double
Double
Precision of 15 digits
Int
Integer
-2,147,483,648 to 2,147,483,647
Nstring
String
1 to 104,857,600 characters
Number
Decimal
For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
If you specify the precision greater than the maximum number of digits, the Data Integration Service converts decimal values to double in high precision mode.
If the precision is greater than 15, the Data Integration Service converts decimal values to double in low-precision mode.
String
String
1 to 104,857,600 characters
TimestampWithTZ
TimestampWithTZ
Aug. 1, 1947 A.D to Dec. 31, 2040 A.D.
-12:00 to +14:00
Precision of 36 and scale of 9.
(precision to the nanosecond)
Timestamp with Time Zone data type does not support the following time zone regions:
  • AFRICA_CAIRO
  • AFRICA_MONROVIA
  • EGYPT
  • AMERICA_MONTREAL
TimestampWithTZ is applicable only to the native environment.
When the
Data
Integration Service reads non-numeric data in a numeric column from a flat file, it drops the row and writes a message in the log. Also, when the
Data
Integration Service reads non-datetime data in a datetime column from a flat file, it drops the row and writes a message in the log.


Updated September 28, 2020