PowerCenter
- PowerCenter 10.4.0
- All Products
Special Character | Target Designer Behavior | Mapping Designer Behavior |
---|---|---|
| Retains the character in the target definition table name. Retains the character in the target definition column names. | Retains the character in the target instance table name. Retains the character in the target instance column names. Does not use quotation marks around the table or column names in the target update override. |
| Retains the character in the target definition table name. Retains the character in the target definition column names. | Replaces the character in the target instance table name with the underscore character. Retains the character in the target instance column names. Delimits table and column names including special characters with quotation marks in the target update override. |
| The Designer does not recognize these characters in relational target table and column names. | The Designer does not recognize these characters in relational target table and column names. |
Special Character | Target Designer Behavior | Mapping Designer Behavior |
---|---|---|
| Retains the character in the target definition table name. Retains the character in the target definition column names. You cannot use the @ character as the first character in a table or column name. | Retains the character in the target instance table name. Retains the character in the target instance column names. You cannot use the @ character as the first character in a table or column name. |
| Retains the character in the target definition table name. Retains the character in the target definition column names. | Replaces the character in the target instance table name with the underscore character. Retains the character in the target instance column names. |
| The Designer does not recognize these characters in non-relational target table and column names. | The Designer does not recognize these characters in non-relational target table and column names. |