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.

Answer / saradhi

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

Answer / amedela chandra sekhar

unsorted data loading into aggregate cache.

Answer / ram kumar

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

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.

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

Define informatica repository?

2 Answers   Wipro,

plz plz plz send client names and project names in informatica?

1 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

what is diffrence b/w joner and union transfermation

6 Answers  

can we override a native sql query within informatica? Where do we do it?

0 Answers  

what is the monster dimension plz give me one example

2 Answers   EDS,

What do you mean by worklet?

0 Answers  

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers