Incremental loading

How to design a job with incremental loading in datastage?

Questions by amulas   answers by amulas

Showing Answers 1 - 1 of 1 Answers

Divya

  • Jul 14th, 2011
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions