In this example, table f_table1 uses the staging_db_two database. The database specified at the database level, staging_db_one, is overridden. The table f_table2 uses the staging_db_one database that is specified at the database level.
<database selection="unselected"> <name>DBName</name> <source_staging_database> <name>staging_db_one</name> </source_staging_database> <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>