For example, you want to extract data from a customers table. The customers table has multiple schemas that contain customer information for different countries. You want to use one mapping to extract data from multiple schemas based on the country name instead of creating different mappings for different schemas. In this case, you can parameterize the owner name and source table name in the session properties, and use the same mapping to extract data from multiple schemas.

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

Delimiter
EscapeCharacter
NullValue
Owner Name
Db2 Warehouse Pre SQL
Db2 Warehouse Post SQL
Source Filter
Source Table Name
SQL Query
User Defined Join