PowerExchange for Email Server User Guide for PowerCenter

10.5.1
- 10.5.4
- 10.5
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Email and Transformation Datatypes

Email and Transformation Datatypes