Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

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.

0 COMMENTS

We’d like to hear from you!