How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
Answer Posted / 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 View All Answers
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Can you implement SCD2 using join, transformer and funnel stage?
what is use of SDR function?
What are the differences between datastage and informatica?
AGGREGATOR default datatype
What is the importance of the exception activity in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between in process and inter process?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the roundrobin collector?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between account and directory options ?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Differentiate between validated and Compiled in the Datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?