Support to deploy specific tables
From 10.1 release, ETL viz XMDBTool supports the deploying of ETL data
to specific tables, using the
deploy_specified_tables
parameter. When this parameter
is used, only the specified tables are mapped. You can specify multiple tables
separated by a colon. The
deploy_specified_tables
parameter is used with the
startDate
and the
endDate
parameters. You can also use this parameter in a
full etl run. If the
toFile
parameter is not specified, the
db - to - dbtranformation
process is used. When dates
are specified in the command line, add a % between the data and the time part.
Example 1:
run_etl bat -deploy_tables Y -mapping_classes USER_HIERARCHY -toFile C:\Nitesh\test1.sql -deploy_specified_tables EXPENSE_REPORT:EXPENSE_REPORT_LINE_ITEM
Example 2:
run_etl.ba t -deploy_specified_tables EXPENSE_REPORT:EXPENSE_REPORT_LINE_ITEM-startDate 01-01-2016%00:00:00 -endDate 01-01-2017%00:00:00