Read historical data in the first run

[Siva_Venna]

I have a pipeline that extracts data from Oracle table and write data to destination. Oracle select snap will read current day’s date based on a time field. When I am migrating this pipeline to PROD environment in the first run it should read entire data(historical data) and from second run it should read current day data. how to design this ?Thanks

[Supratim]

[full_incremental_load_2020_09_25.slp|attachment]
Try this way

(upload://mpHeJ7IYL1IB9KyKwa2VlgD2FtY.slp) (19.7 KB)