How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
time extraction?
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 |
what is data mapping
How can we do null handling in sequential files
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
How to find value from a column in a dataset?
which memory is used by lookup and join
How a server job can be converted to a parallel job?
what is time dimension? and how to populate time demension
How many types of hash files are there?
in aggregator , how can i get the sum in readable format
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
What is difference between symmetric multiprocessing and massive parallel processing?
is it possible to access the same job by two users at a time in DataStage?