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
Define enterprise data warehousing?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Define Pmrep command?
Explain what are the different types of transformation available in informatica.
How to use procedural logic inside infromatica?
What is rank transform?
What is main use of mapplet?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a code page?
What is an unconnected transformation?
What are the main features of Oracle 8i with context to datawarehouse?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How you can differentiate between connected lookup and unconnected lookup?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?