What is aggregate cache in aggregator transforamtion?

The aggregator stores data in the aggregate cache until it completes aggregate calculations.When u run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If the informatica server requires more space,it stores overflow values in cache files.

  • Interview Candidate
  • 7
  • 15655

Showing Answers 1 - 7 of 7 Answers

sithusithu

  • Jan 19th, 2006
 

When you run a workflow that uses an Aggregator transformation, the Informatica Server creates index and data caches in memory to process the transformation. If the Informatica Server requires more space, it stores overflow values in cache files.

Cheers,

Sithu

  Was this answer useful?  Yes

bneha15

  • Apr 18th, 2007
 

Aggregate cache contains data values while aggregate calculations are being performed. Aggregate cache is made up of index cache and data cache. Index cache contains group values and data cache consists of row values.

  Was this answer useful?  Yes

chandrarekha

  • Sep 24th, 2007
 

when  server runs the session with aggregate transformation ,it stores data in memory until it completes the aggregation
when u partition a source ,the server creates one memory cache and one disk cache for each partition .it routes the data from one partition to another based on group key values of the transformation

  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