What is incremental aggregation and how it is done?
Answer Posted / sivaprasad
Gradually to synchronize the target data with source data,
there are further 2 techniques:-
Refresh load - Where the existing data is truncated and
reloaded completely.
Incremental - Where delta or difference between target and
source data is dumped at regular intervals. Timsetamp for
previous delta load has to be maintained.
| Is This Answer Correct ? | 15 Yes | 13 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
What is union transformation in informatica?
What is flashback table ? Advance thanks
Where are the source flat files kept before running the session?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is blocking transformation?
How can we use batches?
What is fact table? Explain the different kinds of facts.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is Data Caches size?
How to extract sap data using informatica?
What is sq transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the types of caches in lookup? Explain them.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?