Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Properties of PowerCenter Transformation Data Types

Properties of PowerCenter Transformation Data Types

When you create a field expression, you must know the precision values and scale values to set for the PowerCenter transformation data type that you select for the expression. Incorrect values can lead to errors and result truncation. You can change the values of precision and scale for some PowerCenter transformation data types.
Precision is the maximum number of significant digits for numeric data types, or the maximum number of characters for string data types. Precision includes scale. Scale is the maximum number of digits after the decimal point for numeric values. Therefore, the value 11.47 has a precision of 4 and a scale of 2. The string Informatica has a precision (or length) of 11.
The following table describes the properties of the PowerCenter transformation data types:
Data
Type
Size in Bytes
Description
Bigint
8 bytes
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision of 19, scale of 0
Integer value.
Binary
Precision
1 to 104,857,600 bytes
You cannot use binary data for COBOL or flat file sources.
Date/Time
16 bytes
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision of 29, scale of 9
(precision to the nanosecond)
Combined date/time value.
Decimal
8 bytes (if high precision is off or precision is greater than 28)
16 bytes (if precision <= 18 and high precision is on)
20 bytes (if precision > 18 and <= 28)
Decimal value with declared precision and scale. Scale must be less than or equal to precision.
Precision 1 to 28 digits, scale 0 to 28
Double
8 bytes
Double-precision floating-point numeric value.
You can edit the precision and scale. The scale must be less than or equal to the precision.
Integer
4 bytes
-2,147,483,648 to 2,147,483,647
Precision of 10, scale of 0
Integer value.
Nstring
Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
1 to 104,857,600 characters
Fixed-length or varying-length string.
Ntext
Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
1 to 104,857,600 characters
Fixed-length or varying-length string.
Real
8 bytes
Precision of 7, scale of 0
Double-precision floating-point numeric value.
Small Integer
4 bytes
-32,768 and 32,767
Precision of 5, scale of 0
Integer value.
String
Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
1 to 104,857,600 characters
Fixed-length or varying-length string.
Text
Unicode mode: (precision + 1) * 2
ASCII mode: precision + 1
1 to 104,857,600 characters
Fixed-length or varying-length string.
The following table shows the PowerCenter transformation data type properties that you can change:
PowerCenter Transformation Data Type
Precision Can Be Changed
Scale Can Be Changed
Bigint
No
-
Binary
Yes
-
Date/time
No
No
Decimal
Yes
Yes
Double
No
-
Integer
No
-
Nstring
Yes
-
Ntext
Yes
-
Real
No
-
Small integer
No
-
String
Yes
-
Text
Yes
-