What is incremental aggregation and how it is done?
Answer Posted / bharat
Incremental aggregation is a technique by which we can
capture the aggregated data incrementally.
for this we have to sort the data before sending it to
aggregator then we have to enable the property incremental
aggregation in the workflow level inside the session.
| Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
what is the size of your data warehousing?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How you prepared reports for OLAP?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
update strategy transformation in informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is Session and Batches?
What is lookup transformation?
What can we do to improve the performance of informatica aggregator transformation?
How does a sorter cache works?
Explain the difference between mapping parameter and mapping variable?
How to update or delete the rows in a target, which do not have key fields?
where to store informatica rejected data?
What do mean by local and global repository?