Rules and guidelines for PowerCenter sources and targets
Observe the following rules and guidelines for sources and targets in a PowerCenter task:
•Do not include Nvarchar2 columns in Oracle targets. Due to an ODBC driver limitation, the PowerCenter task truncates the last half of Nvarchar2 data before writing it to Oracle targets.
•Do not write Decimal data of 2147483648 or larger to Microsoft SQL Server or ODBC Integer(10) columns. Doing so can cause unexpected results.
Guidelines for sources and targets in data integration tasks