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



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

What is process model?

0 Answers  


What is the difference between the local container and shared container?

0 Answers  


i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


Define Data Stage?

0 Answers  






i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output  aaa bbbb ccccc Ple help any one?

4 Answers   SLK Software,


What is the difference between datastage and informatica?

0 Answers  


which unix commands mostly used in datastage

3 Answers   HSBC,


types of errors in datastage?

2 Answers   Reliance,


What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  


in oracle target stage when we use load option and when we use upsert option?

0 Answers  


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,


Categories