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

Explain Quality stage?

0 Answers

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers

What is the difference between passive stage and active stage?

0 Answers

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers TCS,

How we can convert rows to columns in datastage?

4 Answers IBM,

Difference between server jobs & parallel jobs?

0 Answers

what r the sources u need to create the datastage?

1 Answers

How to create environments and call them? What is the use defined variables?

2 Answers HCL, ME,

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers Amdocs,

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?