Informatica Data Quality
- Informatica Data Quality 10.5.3
- All Products
Data Type
| Range
| Transformation
| Range
|
---|---|---|---|
Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Blob
| 1 to 2,147,483,647 bytes
| Binary
| 1 to 104,857,600 bytes
|
Char
| 1 to 254 characters
| String
| 1 to 104,857,600 characters
|
Char for bit data
| 1 to 254 bytes
| Binary
| 1 to 104,857,600 bytes
|
Clob
| 1 to 2,447,483,647 bytes
| Text
| 1 to 104,857,600 characters
|
Date
| 0001 to 9999 A.D.
Precision 19; scale 0 (precision to the day)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Dbclob
| 1 to 1073741823 bytes
| Dbclob
| 1 to 104,857,600 bytes
|
Decimal
| Precision 1 to 31, scale 0 to 31
| Decimal
| Precision 1 to 31, scale 0 to 31
|
Float
| Precision 1 to 15
| Double
| Precision 15
|
Graphic
| 1 to 127 bytes
| Graphic
| 1 to 127 bytes
|
Integer
| -2,147,483,648 to 2,147,483,647
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
Long Varchar
| 32700 bytes
| Long Varchar
| 32700 bytes
|
Long Vargraphic
| 163350 bytes
| Long Vargraphic
| 163350 bytes
|
Numeric
| Precision 1 to 31, scale 0 to 31
| Decimal
| Precision 1 to 28, scale 0 to 28
|
Smallint
| -32,768 to 32,767
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
Time 1
| 24-hour time period
Precision 19, scale 0
(precision to the second)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Timestamp
| 26 bytes
Precision 26, scale 6
(precision to the microsecond)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Varchar
| Up to 4,000 characters
| String
| 1 to 104,857,600 characters
|
Varchar for bit data
| Up to 4,000 bytes
| Binary
| 1 to 104,857,600 bytes
|
Vargraphic
| 1 to 16336 bytes
| Vargraphic
| 1 to 16336 bytes
|
1. When the Data Integration Service converts the DB2 Time data type to the transformation Date/Time data type, the date value is added to the time value.
|