If u select groupby port in aggregator what is output and
dont select groupby option what is output

Answers were Sorted based on User's Feedback



If u select groupby port in aggregator what is output and dont select groupby option what is outpu..

Answer / ash

If we select a group by port then : we get the last row of
each group based on the group by port.

If we didn't select a group by port: we get only one row
that is the last row .

Is This Answer Correct ?    12 Yes 1 No

If u select groupby port in aggregator what is output and dont select groupby option what is outpu..

Answer / chandrababu naidu

last row as output

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,


Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,


What is joiner cache?

2 Answers   TCS,


differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,


write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,






Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


what type of transformation is not supported by mapplets?

4 Answers   CTS,


What is difference between a gateway node and worker node?

0 Answers  


How to update a particular record in target with out running whole workflow?

0 Answers  


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,


whatis the default data driven operation in informatica

2 Answers  


Categories