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

1 Answers
5776 Views
Infosys, TCS, I also Faced
E-Mail Answers

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

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers HCL,

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers Accenture,

What is lookup table?

5 Answers

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers IBM,

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers IBM,

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers

What are the different options associated with dsjob command?

0 Answers

how can u find out the datastage job is running on how many nodes