How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?



How can we perform 2nd time extraction of client database without accepting the data which is alr..

Answer / ravi

Take PK of records inserted in 1st extraction from Target Database table. Write a query to exclude these records from client DB in 2nd extraction.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

what is data mapping

2 Answers  


How can we do null handling in sequential files

3 Answers   Reliance,


if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


which memory is used by lookup and join

5 Answers   IBM,


How a server job can be converted to a parallel job?

0 Answers  


what is time dimension? and how to populate time demension

2 Answers   TCS,


How many types of hash files are there?

0 Answers  


in aggregator , how can i get the sum in readable format

4 Answers   IBM,


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,


Categories