In this example, table f_table1 uses staging_db_two as its source staging database and table f_table2 does not specify the staging database name at the table level. This results in the table using the source table database, MyDB, as the source staging database.
<database selection="unselected"> <name>MyDB</name> <table selection="included"> <name>f_table1</name> <use_source_staging_table>TRUE</use_source_staging_table> <source_staging_database> <name>staging_db_two</name> </source_staging_database> </table> <table selection="included"> <name>f_table2</name> <use_source_staging_table>TRUE</use_source_staging_table> </table> </database>