How can we perform 2nd time extraction of client database without accepting t

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

Question Posted / tallamaheshgoud

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

More Data Stage Interview Questions

Wat is pre-load in Hashed file

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

what is meta data? Explain? Where it is used?

what is set mapping in datastage??

What is the command line function to import and export the ds jobs?

What is the difference between in process and inter process?

What is a quality stage in datastage tool?

What are the prerequisites for join stage

How to generate surrogate key without using surrogate key stage?

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

DataStage Scenario based Interview Questions

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

For more Data Stage Interview Questions Click Here