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) '
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