This content has been marked as final. Show 1 reply
You have to execute only 1 EP for both Incr and Full loads, followed by another custom EP which set the DAC refresh table(W_ETL_REFRESH_DT) column as NULL.
ex:UPDATE W_ETL_REFRESH_DT SET LAST_REFRESH_DT =NULL
You need to schedule the custom ep to run on only Saturdays just before your actual EP start time so that you can have DAC refresh dates are null and follow load would be full load.
You need to create a custom etl mapping so that you can set this.. that might be a command from session or workflow.
If helps pls mark as correct :)
Edited by: Srini VEERAVALLI on Jan 24, 2013 8:22 AM