Informatica Data Quality
- Informatica Data Quality 10.5
- All Products
SAP HANA Datatype
| Range
| Transformation Datatype
| Range
|
---|---|---|---|
Alphanum
| Precision 1 to 127
| Nstring
| 1 to 104,857,600 characters
|
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
|
Binary
| Used to store bytes of binary data
| Binary
| 1 to 104,857,600 bytes
|
Blob
| Up to 2 GB
| Binary
| 1 to 104,857,600 bytes
|
Clob
| Up to 2 GB
| Text
| 1 to 104,857,600 characters
|
Date
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 10, scale 0
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Decimal (precision, scale) or Dec (p, s)
| Precision 1 to 34
| 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.
|
Double
| Specifies a single-precision 64-bit floating-point number
| Double
| Precision 15
|
Float
| Precision 1 to 53
| Double
| Precision 15
|
Integer
| -2,147,483,648 to 2,147,483,647
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
NClob
| Up to 2 GB
| Ntext
| 1 to 104,857,600 characters
|
Nvarchar
| Precision 1 to 5000
| Nstring
| 1 to 104,857,600 characters
|
Real
| Specifies a single-precision 32-bit floating-point number
| Real
| Precision 7, scale 0
|
Seconddate
| 0001-01-01 00:00:01 to 9999-12-31 24:00:00
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Shorttext
| Specifies a variable-length character string, which supports text search and string search features
| Nstring
| 1 to 104,857,600 characters
|
Smalldecimal
| Precision 1 to 16
| Decimal
| Precision 1 to 28, scale 0 to 28
|
Smallint
| -32,768 to 32,767
| Small Integer
| Precision 5, scale 0
|
Text
| Specifies a variable-length character string, which supports text search features
| Text
| 1 to 104,857,600 characters
|
Time
| 24-hour time period
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Timestamp
| 0001-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Tinyint
| 0 to 255
| Small Integer
| Precision 5, scale 0
|
Varchar
| Precision 1 to 5000
| String
| 1 to 104,857,600 characters
|
Varbinary
| 1 to 5000 bytes
| Binary
| 1 to 104,857,600 bytes
|