Designer Guide

10.5.7
- 10.5.6
- 10.5
- 10.4.1
- 10.4.0

Back Next

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.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Special Character Handling in Target Definitions

Special Character Handling in Target Definitions