1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Post New Answer

More Data Stage Interview Questions

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

Can you explain kafka connector?

0 Answers  

where we use config file as parameter ?

1 Answers   IBM,

What is PX?

2 Answers   IBM,

Define Data Stage?

0 Answers  




Define repository tables in datastage?

0 Answers  

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

Explain how a source file is populated?

0 Answers  

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

5 Answers   Gallega, TCS,

What is staging variable?

0 Answers  

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

What are the functionalities of link collector?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories