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
5693 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

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers Wipro,

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers HCL,

What are the functionalities of link partitioner and link collector?

0 Answers

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers Cognizant, IBM, TCS, Virtusa,

What are the job parameters?

0 Answers

What is the difference between hashfile and sequential file?

0 Answers

what is A Datastage?

2 Answers

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

3 Answers TCS,

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers

Explain usage analysis in datastage?