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

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,


What is a surrogate key?

0 Answers  


How can you complete unrcoverable sessions?

1 Answers  


What is depict expression change?

0 Answers  






write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,


what is polling?

1 Answers   Informatica,


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


In which transformation you cannot drag ports into it?

0 Answers   Informatica,


How to go to the older version for a mapping?

0 Answers  


How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  


What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,


Categories