For example, you want to load data to a sales table. The sales table has multiple schemas to store sales information for different countries. You want to use one mapping to load data to multiple schemas based on the country name instead of creating different mappings for different schemas. In this case, you can parameterize the target table name and table name prefix in the session properties, and use the same mapping to load data to multiple schemas.

You can parameterize the following session properties for Db2 Warehouse targets:

Db2 Warehouse Post SQL
Db2 Warehouse Pre SQL
Delimiter
Error Log Directory Name
Escape Character
Null Value
Pipe Directory Path
Socket Buffer Size
Table Name Prefix
Target Table Name