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.

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

What is a joiner transformation?

0 Answers  

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

What do you mean by filter transformation?

0 Answers  

Define Update Override?

1 Answers  

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

what is degenerated dimension

6 Answers   Cap Gemini,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

How can one identify whether mapping is correct or not without connecting session?

0 Answers