Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Special Character Handling in Target Definitions

Special Character Handling in Target Definitions

You can import, create, and edit target definitions with table and field names containing special characters, such as the slash (/) character through the Designer. When you import, create, or edit a target definition using the Target Designer, the Designer retains special characters in table and field names when saving the target definition to the repository.
However, when you add a target definition with special characters to a mapping, the Designer either retains or replaces the character. Also, when you generate the target update override in target instance in the Target Designer, the Designer uses quotation marks around table and column names with some special characters. The Designer handles special characters differently for relational and non-relational targets.
The following table describes how the Designer handles special characters in relational targets:
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.
/+-=~`!%^&*()[]{}'; ?,<>\| <space>
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.
.":\t\r\n
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.
The following table describes how the Designer handles special characters in non-relational targets:
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.
.+-=~`!%^&*()[]{}'" ;:?,<>\| \t\r\n <space>
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.
Some databases require special configuration or commands to allow table and field names containing special characters. For more information, see the database documentation.


Updated June 25, 2018