PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Email and Transformation Datatypes

Email and Transformation Datatypes

PowerCenter uses the following datatypes in email mappings:
  • Email native datatypes. Email datatypes appear in email definitions in a mapping.
  • Transformation datatypes. Set of datatypes that appear in the transformations. They are internal datatypes based on ANSI SQL-92 generic datatypes, which the PowerCenter Integration Service uses to move data across platforms. They appear in all transformations in a mapping.
When the PowerCenter Integration Service reads source data, it converts the native datatypes to the comparable transformation datatypes before transforming the data.
The following table lists the Email datatypes that PowerCenter supports and the corresponding transformation datatypes:
Email
Datatype
Description
Transformation Datatype
Description
Date/Time
Jan 1, 1970 A.D. to Dec 31, 9999 A.D.
(precision to millisecond)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to nanosecond)
DBinary
1 to 104,857,600 bytes
Binary
1 to 104,857,600 bytes
Numeric
Precision 1 to 31, scale 0
Decimal
Precision 1 to 28, scale 0 to 28
String
No limit
String
1 to 104,857,600 characters