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

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,


What is the advantage of informatica?

0 Answers  


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

4 Answers   ABC, Cap Gemini,


whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


what is polling?

1 Answers   Informatica,






How to display First letter of Names in Caps?

7 Answers  


What is difference macros and prompts?

2 Answers  


How to eliminate duplicates from flat file..what is the procedure

4 Answers  


explain about unit testing? in real time?

0 Answers   L&T,


checkout and checkin in informatica 8.6

3 Answers   TCS,


disable caching in a lookup transformation?

1 Answers  


Issue with Update override at Target table in Informatica.

2 Answers  


Categories