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

JDBC and Transformation Datatypes

JDBC and Transformation Datatypes

When the Data Integration Service reads data from a JDBC source, it converts the native datatypes into the corresponding JDBC datatypes and then to the transformation datatypes. It uses the transformation datatypes to move data across platforms.
The following table compares the JDBC datatypes to the transformation datatypes:
JDBC Datatype
Transformation
Range
Bigint
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Binary*
Binary
1 to 104,857,600 bytes
Bit
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Blob*
Binary
1 to 104,857,600 bytes
Boolean
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Char*
String
1 to 104,857,600 characters
Clob*
Text
1 to 104,857,600 characters
Date
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal
Decimal
Precision 1 to 28, scale 0 to 28
Double
Double
Precision 15
Float
Double
Precision 15
Integer
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Long VarBinary*
Binary
1 to 104,857,600 bytes
Long Varchar*
Text
1 to 104,857,600 characters
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Real
Double
Precision 15
Smallint
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Time
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Tinyint
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Varchar*
String
1 to 104,857,600 characters
Varbinary*
Binary
1 to 104,857,600 bytes
*If the size of data in a port is greater than 100 MB, the Developer tool sets the port precision to 4000 by default. To process data with a larger size, increase the port precision.

0 COMMENTS

We’d like to hear from you!