What is incremental aggregation and how it is done?
Answer Posted / eswar
When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.
Is This Answer Correct ? | 21 Yes | 2 No |
Post New Answer View All Answers
What are Dimensional table?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to improve the performance of a session using sorter transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the way to execute pl/sql script using informatica mapping?
what is the complex transformation you used in informatica
What is the difference between stop and abort in informatica
What is the difference between router and filter?
How we can create indexes after completing the load process?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain what is informatica metadata and where is it stored?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is depict expression change?
can anyone suggest best free Talend data integration training online