Informatica Data Quality
- Informatica Data Quality 10.5.6
- All Products
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.
|