You can override the target table name in the target definition. 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 field. You can also enter a parameter or variable.
You can override the target name at the session level. The target table name you set at the session level overrides the target table name you set in the target definition.