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.

what are the transformations that restricts the partitioning of sessions?

1 Answers  

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

What is the difference between router and filter?

0 Answers  

What is the default join that source qualifier provides?

3 Answers   Informatica,

What are active transformations.

0 Answers  

How does the session recovery work.

1 Answers  

what is the diff b/w union and joiner and lookup?

4 Answers  

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What do you mean by enterprise data warehousing?

0 Answers  

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

How can you increase the performance in joiner transformation?

0 Answers