Aggregator transformation is having fields say a,b,c,d,e group
by is enabled on a,b,c with sorted input,How the aggregator
transformation process the i/p data?or in which way i/p comes
to agg transformation



Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted ..

Answer / priyank

Aggregator transformation will pass the output as the last
row coming in for the group a,b,c.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  


I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,


Explain the types of lookup transformation?

0 Answers  


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


What all join we can perform in LOOKUP transformation?

0 Answers  


Can we create multiple integration service on single repository?

0 Answers  


How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,


MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


Categories