Sources and Targets
Use the following rules and guidelines for sources and targets that are used in a PowerCenter task:
- •Field names must contain only alphanumeric or underscore characters. Do not use spaces in field names.
- •Field names cannot start with a number.
- •Each field name must be unique within each source and target object.
- •The scale or precision of a numeric target column should be the same or greater than the scale or precision of the corresponding source column. Otherwise, the PowerCenter task truncates the data.
- •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.