When you configure a target with an existing schema, you can optionally define rules for renaming the target tables that correspond to the selected source objects.
To create a rule for renaming tables, perform the following steps in the
Table Renaming Rules
section:
In the
Create Rule
fields, enter the name of the source object that you want to rename and then enter the name that you want to assign to the target table corresponding to the object.
You can enter only the asterisk (*) wildcard character to select all source objects that match the selection criteria defined on the
Source
page. Alternatively, you can enter the name of a specific source object or an object-name pattern that includes the asterisk (*) wildcard character.
If an object or table name includes special characters such as a backslash (\), asterisk(*), dot (.), or question mark (?), replace each special character in the name with a backslash (\) when you create the rule.
If you want to use an table-name pattern with a wildcard character for the target table, you must also use the wildcard character in the name of the corresponding source object.
Click
Add Rule
.
The rule is created and appears in the rules list.
You can define multiple table renaming rules. Unless a table matches multiple rules, the order in which the rules are processed does not depend on the order in which they are listed in the
Table Renaming Rules
section. If a table matches multiple rules, the last matching rule determines the name of the table.
To delete a rule, click the Delete icon on the row that contains the rule.
Example
You want to add the prefix "PROD_" to the names of target tables that are associated with all selected source objects. In the
Table Renaming Rules
section, enter the following values in the
Create Rule
fields:
For the source, enter the asterisk (*) wildcard character to specify all the source objects that match the object selection rules defined on the
Source
page.
For the target, enter PROD_* to add this prefix to the names of all target tables corresponding to the source objects.
ASK INFAPreview
