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 difference between stored procedure transformation and external procedure transformation?

2 Answers  


How to import oracle sequence into Informatica?

3 Answers   Satyam,


Explain transaction control transformation in informatica

0 Answers   Informatica,


what are the types of facts with Examples?

3 Answers  


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,






my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,


Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,


Make a note of the quantity vaults made in informatica?

0 Answers  


Categories