GeekInterview.com
Series: Subject: Topic:
Question: 28 of 444

Incremental loading

how to design a job with incremental loading in datastage?
Asked by: amulas | Member Since Jun-2011 | Asked on: Jul 13th, 2011

View all questions by amulas   View all answers by amulas

Showing Answers 1 - 1 of 1 Answers
Divya

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.