You can override the target table name in the target instance of a mapping. Override the target table name when you use a single mapping to load data to different target tables. Enter a table name in the target table name. You can also enter a parameter or variable. You can use mapping parameters, mapping variables, session parameters, workflow variables, or worklet variables in the target table name. For example, you can use a session parameter, $ParamTgtTable, as the target table name, and set $ParamTgtTable to the target table name in the parameter file.
To override a target table name:
In the Designer, open the Mapping Designer.
Double-click the title bar of a relational target instance in the mapping.
On the Properties tab, enter the target table name. Or, enter a parameter or variable name in the Target Table Name field.
If you use a user-defined mapping parameter, mapping variable, workflow variable, or worklet variable, you must declare the parameter or variable.
Click OK.
If you use a parameter or variable for the target table name, define the parameter or variable in the appropriate section of the parameter file.