Informatica Data Quality
- Informatica Data Quality 10.5.1
- All Products
Nonrelational
| Precision
| Transformation
| Range
|
---|---|---|---|
BIN
| 10
| Binary
| 1 to 104,857,600 bytes
|
CHAR
| 10
| String
| 1 to 104,857,600 characters
Fixed-length or varying-length string.
|
DATE
| 10
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
|
DOUBLE
| 18
| Double
| Precision of 15 digits
Double-precision floating-point numeric value.
|
FLOAT
| 7
| Double
| Precision of 15 digits
Double-precision floating-point numeric value.
|
NUM8
| 3
| Integer
| Precision of 10 and scale of 0
Integer value.
|
NUM8U
| 3
| Integer
| Precision of 10 and scale of 0
Integer value.
|
NUM16
| 5
| Integer
| Precision of 10 and scale of 0
Integer value.
|
NUM16U
| 5
| Integer
| Precision of 10 and scale of 0
Integer value.
|
NUM32
| 10
| Integer
| Precision of 10 and scale of 0
Integer value.
|
NUM32U
| 10
| Double
| Precision of 15 digits
Double-precision floating-point numeric value.
|
NUM64
| 19
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|
NUM64U
| 19
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|
NUMCHAR
| 100
| String
| 1 to 104,857,600 characters
Fixed-length or varying-length string.
|
PACKED
| 15
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|
TIME
| 5
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
|
TIMESTAMP
| 5
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Combined date/time value, with precision to the nanosecond.
|
UPACKED
| 15
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|
UZONED
| 15
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|
VARBIN
| 10
| Binary
| 1 to 104,857,600 bytes
|
VARCHAR
| 10
| String
| 1 to 104,857,600 characters
Fixed-length or varying-length string.
|
ZONED
| 15
| Decimal
| Precision 1 to 28 digits, scale 0 to 28
Decimal value with declared precision and scale. Scale must be less than or equal to precision. If you pass a value with negative scale or declared precision greater than 28, the Data Integration Service converts it to a double.
|