I have done daily incremental load using last_refresh_dt in several projects but today I got new requirement to do hourly incremetal load.
anyone of you work on similar requirement before?
Thanks for your help
if its for a existing subject area, and as long as it does not impact your daily loads, you can use Micro ETLs:
http://docs.oracle.com/cd/E12104_01/books/DAC/DADesignETL17.html Pls mark correct or helpful
It does impact daily incremental load if I use hourly load using DAC so instead of using DAC I scheduled using Informatica. obviously I can't use last_refresh_dt as parameter for hourly load then what could be the criteria for hourly load?