What is the use of incremental aggregation? Explain me in brief with an example.

Showing Answers 1 - 2 of 2 Answers

its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

  Was this answer useful?  Yes

srinivas vadlakonda

  • Sep 28th, 2006
 

Incremental aggregation is in session properties i have 500 records in my source and again i got 300 records if u r not using incremental aggregation what are calculation r using on 500 records again that calculation will be done on 500+ 300 records, if u r using incremental aggregation calculation will be done one only what are new records (300) that will be calculated dur to this one performance will increasing.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions