Rules and Guidelines for PowerCenter Sources and Targets
Use the following rules and guidelines for sources and targets in a PowerCenter task:
- •Field names must contain only alphanumeric or underscore characters. Spaces are not allowed.
- •Field names cannot start with a number.
- •Each field name must be unique within each source and target object.
- •The PowerCenter task truncates the data if the scale or precision of a numeric target column is less than the scale or precision of the corresponding source column.
- •The import fails if Informatica Cloud does not support the source and target connection types that are imported with the PowerCenter workflow.
- •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.