Dimple

• Dec 5th, 2005

 

You can create a table where u can store the last successfull refresh time for each table/Dimension.

Then in the source query take the delta of the last successful and sysdate should give you incremental load.

Sivarao

• Dec 27th, 2005

 

Incremental load means daily load.

when ever you are selecting data from source, select the records which are loaded or updated between the timestamp of lastsuccessful load and todays load start date and time.

for this u have to pass parameters for those two dates.

store the last rundate and time in a file and read the parameter through job parameters and state second argument as currentdate and time.