Data Types
This section describes new data type features in version 10.0.
Informatica Data Types
This section describes new data types in the Developer tool.
Decimal Data Type
Effective in version 10.0, some transformations support the Decimal data type with a precision of up to 38 digits. The decimal data type has a precision of 1 to 38 digits and a scale of 0 to 38. All other transformations support the Decimal data type with a precision of up to 28 digits.
For transformations that support the Decimal data type of precision up to 38 digits, when the target contains a precision that is greater than 38 digits and has high precision enabled, the Data Integration Service stores the result as a double.
For more information, see the "Data Type Reference" appendix in the Informatica 10.0 Developer Tool Guide.
Mappings with the Decimal 38 Data Type
Effective in version 10.0, if you run a mapping that contains fields with precision greater than 28 but less than or equal to 38 in high precision mode, the Data Integration Service processes a precision of up to 38 digits. There is no behavior change if the precision is greater than 38 digits post upgrade.
The following table describes the post-upgrade behavior based on the applicable precision:
Precision | Previous | 10.0 |
|---|
Greater than 28 but less than or equal to 38 | Double | Decimal |
Over 38 | Double | Double |
For example, you have the following source data: 12345678901234567890123456789012345678
Previously, the target contains the following data: 12345678901234500000000000000000000000
In 10.0, the target contains the following data: 12345678901234567890123456789012345678
For more information, see the "Data Type Reference" appendix in the Informatica 10.0 Developer Tool Guide.
Timestamp with Time Zone
Effective in version 10.0, most transformations support the Timestamp with Time Zone data type. Timestamp with Time Zone is a variant of the Timestamp data type that includes a time zone offset.
When you import the Timestamp with Time Zone data type into the Developer tool, the associated transformation data type is timestampWithTZ. Timestamp with Time Zone has a precision of 36 and a scale of 9. Timestamp with Time Zone displacement value range is from -12:00 < UTC < +14:00.
For more information, see the "Data Type Reference" appendix in the Informatica 10.0 Developer Tool Guide.
Timestamp with Local Time Zone
Effective in version 10.0, Timestamp with Local Time Zone data type is another variant of the Timestamp data where the time zone data is normalized to the database time zone.
When you import the Timestamp with Local Time Zone data type into the Developer tool, the associated transformation data type is timestamp. The Timestamp with Local Time Zone data type is implicitly supported by most transformations as the functionality is equivalent to Timestamp.
Timestamp with Local Time Zone has a precision of 26 and a scale of 6. It is mapped to the date/time (29,9) transformation data type.
For more information, see the "Data Type Reference" appendix in the Informatica 10.0 Developer Tool Guide.