Abhijain

 Profile Answers by Abhijain 

• Oct 14th, 2009

 

There are ways to perform the incremental load. While performing incremental load, Pls take care of below points:
1. Retrieve changed records from last load run from source by using appropriate extract query.
2. Perform a look up with the target database of changed records from source and create target dataset.

Now, there are two ways to perform Incremental load.

a) Using Datastage SCD Stage.
b) Use Change Capture Stage for capturing the actual change between source and target dataset and perform incremental load into the target database.

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Oct 15th, 2009

 

Abhijain is right. If you compare source with target using either lookup or change capture you can perform Incremental loading.
But my requirement is I have a job like,
Source-------->Transformer---------------->Target without changing my job design,

I have to perform incremental loading.

Thanks for your reply.
Veeru.