What is aggregate cache in aggregator transforamtion?

Answers were Sorted based on User's Feedback



What is aggregate cache in aggregator transforamtion? ..

Answer / ravi sadanand

It is place where all the rows entering the Aggregator
Transformation will be placed till the aggregate
calculations like sum,Avg are made.
all the group information will be stored in index files and
row data in data cache.

Is This Answer Correct ?    3 Yes 1 No

What is aggregate cache in aggregator transforamtion? ..

Answer / saradhi

aggregate cache is used to aggregate the data for that we
are using data cache.

Is This Answer Correct ?    0 Yes 1 No

What is aggregate cache in aggregator transforamtion? ..

Answer / amedela chandra sekhar

unsorted data loading into aggregate cache.

Is This Answer Correct ?    0 Yes 1 No

What is aggregate cache in aggregator transforamtion? ..

Answer / ram kumar

Cache is used to increase the performance of the mapping.
There r 2-typs of cache: Data & Index Cache

Is This Answer Correct ?    0 Yes 2 No

What is aggregate cache in aggregator transforamtion? ..

Answer / saradhi

In aggrefate cache we have 2 types of caches are there
1) Index
2) Data
Index cahce data is used for sorting purpose.
data is used for storing the data.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


What is confirmed dimension with scenario

1 Answers   HCL,


Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,






What is aggregator transformation in informatica?

0 Answers  


Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  


How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,


why union is active transformation?

4 Answers   IBM,


How to import oracle sequence into Informatica?

3 Answers   Satyam,


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


what is bridge tables in informatica

1 Answers   CTS,


Categories