Answer Posted / suraj kedia
Incremental aggregation means applying only the captured
changes in the source to aggregate calculations in a session.
When the source changes only incrementally and if we can
capture those changes,then we can configure the session to
process only those changes.This allows informatica server to
update target table incrementally,rather than forcing it to
process the entire source and recalculate the same
calculations each time you run the session.By doing this
obviously the session performance increases.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Why do we need informatica?
What is the sequence generator transformation in informatica?
Enlist the tasks for which source qualifier transformation is used.
scenario where i can use only concurrent execution of workflow.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How can you validate all mappings in the repository simultaneously?
What is a repository manager?
State the differences between sql override and lookup override?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to improve the performance of a session using sorter transformation?
What is lookup change?
Define joiner transformation?
Explain the mapping variable usage example in informatica
What are the tasks that source qualifier perform?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?