how can we manually set both ETL start date and end date while conducting incremental load IN DAC?
Please advise me.
& Engineering Lombo, told to me
You can set those dates in the DAC system parameters tab. You should see lots of $$xxxxxx parameters.
but can you please give me more clarifications.
for incremental loads, you can use the PRUNE DAYS setting that basically allows you to designate a time frame to capture transactional activity. For instance, you can run INCREMENTAL loads daily but if you set PRUNE DAYS to 5, it will extract 5 days worth of incremental activity. You can set PRUNE DAYS in the DAC for your execution plan. Research PRUNE DAYS in the OBIA documentation
Not sure what you mean by setting the END DATES. For certain OBIA areas (HRMS, eg) you can assign a END DATE in the DAC as well for the future snapshots.