Search This Blog

Tuesday, November 8, 2011

Stage Table Cleanup

When a feed is completed execution, the ETL_ temp tables can be automatically removed from the staging database, or, they can be left in place.

This command controls this behavior:

sets feed to auto remove ETL_ tables:
update config_pkg
set StageCleanUp = 'Y'
where feed_name = '(feed name)'


Sets feed to leave ETL_ tables in place
update config_pkg
set StageCleanUp = 'N'
where feed_name = '(feed name)'

No comments:

Post a Comment