InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Define What Is Aggregate Cache In Aggregator Transformation? |
|
Answer» The aggregator is nothing but a function which stores all the data in the aggregator cache until and unless it deals with all the aggregate CALCULATIONS. So when you are executing a session in which you are using an aggregator transformation, the INFORMATICA server will AUTOMATICALLY start CREATING indexes and data caches in the memory to accommodate and process the transformation. It is a known fact that Informatica server NEEDS more space, it stores the overflow values in all the cache files. The aggregator is nothing but a function which stores all the data in the aggregator cache until and unless it deals with all the aggregate calculations. So when you are executing a session in which you are using an aggregator transformation, the Informatica server will automatically start creating indexes and data caches in the memory to accommodate and process the transformation. It is a known fact that Informatica server needs more space, it stores the overflow values in all the cache files. |
|