Answer / haritha

use sorted input option to decrease the use of aggregator
cache.

use filter transformation before aggregator transformation
to to rduce unnecessary aggregation.

Limit the number of connected input/output or output ports
to reduce the amount of data the Aggregator transformation
stores in the data cache.

Answer / swetha

Use sorted input.

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.

Answer / dilip

if you sort the input yet do not select the sorted input
option, the aggregator treats the data as unsorted data &
performs the task hence its cache size increases. the
performance is degraded despite using a sorter.

Answer / chinna

what u guys said is so far ok
but what happen if u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation so what will happen in
agg by performance wise?

Answer / srikanth

hi haritha

u r correct

For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.

we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.

Answer / sasmita panda

session performance in aggregator T/R can be increased by
aggregation cache i.e through increamental aggregation.
Aggregation cache has tow caches i)index ii) data.

For first run it performs aggregation calculation in
aggregation cache.Index cache contains group by port
values.Data cache will contain if any variable ports are
created and output port on which we want to implement
aggregate function.

Rowid of last record which is participated in Agg. T/R will
be saved in repository.

During second run it finds the rowid of last record then it
performs increamental aggregation.The integration service
will check the historical information in the index cache
file for corresponding group.If it finds it performs
aggregation operation increamentally. If not finds then it
will adda new port for aggreagtion.

Answer / pg

Chinna,
If u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation in that case your session
will fail. You must check the option sorted in
input in aggregator transformation if you are using sorted
input to the aggregator .
Plz let do me know if you still have doubt.
pramodgup@gmail.com

Answer / cherry

hi PG
u r absolutely right.

session will fail.

u have to use the check option for sorted input.

what is mean by flag 4 in update strategy t/r

6 Answers  

what are the transformations that restricts the partitioning of sessions?

1 Answers  

What is the difference between Normal load and Bulk load?

5 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

What are the rank caches?

2 Answers   Informatica,

why dimenstion tables are denormalized in nature ?

3 Answers  

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

What is batch and describe about types of batches?

2 Answers  

How to add source flat file header into target file?

3 Answers   Logica CMG,

What are the types of caches in lookup?

0 Answers