Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule Full ETL, Incremental ETL and Refresh Dates

user10920449Jan 24 2013 — edited Jan 24 2013
Hi - I'm trying to set up a schedule that runs a weekly execution plan on Saturday am. This weekly etl needs to be a full load always. I have a similar execution plan that I want to run all the other mornings as an incremental etl. I have the weekly plan set to run as 'Full Load Always'. Since it is set to run as 'Full Load Always', the refresh dates are not being set on the source tables. The second daily plan then initially runs as a full etl since the refresh dates are null. Is there a way I can accomplish scheduling the weekly execution plan to run as a full and then the daily execution plan to run as incremental without any manual intervention (such as manually resetting the source dates each week) ?

Thank you.
This post has been answered by SriniVEERAVALLI on Jan 24 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2013
Added on Jan 24 2013
1 comment
215 views