If we are using an aggregator but forget to mention the group by port .what w

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

If we are using an aggregator but forget to mention the
group by port .what will be the output??

Question Posted / subhrajit

11 Answers
32341 Views
Nomura, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / srinu

No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.

Any Corrections,,,,,srinu.srinuvas@gmail.com

Is This Answer Correct ?

57 Yes

4 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / kt

If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.

Is This Answer Correct ?

50 Yes

1 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / sheelendra

I agree with Srinu.
and It will return only one aggregated value for all input.

Is This Answer Correct ?

13 Yes

1 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / g. manthiramoorthy

If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat
row of the table to the next transformation

Is This Answer Correct ?

11 Yes

0 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / g. manthiramoorthy

If we miss to enable any of the port as GROUP BY,
the aggregator will write the last row of the table to the
next transformation

Is This Answer Correct ?

8 Yes

0 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / insha

I agree with shreenivas

Is This Answer Correct ?

4 Yes

0 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / vikneswaran

output is single record.for examples

col1
1
1
1
2
2
2
3
3
4
if i use group by and sum(col1) ...
output
col1
3
6
6
4
if i didn't use group by but same agg function
output
col1
19

Is This Answer Correct ?

10 Yes

7 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / guest

Is This Answer Correct ?

0 Yes

0 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / uppala chary

first of all group by port G is mandatory ,if u don't
enable the group by port it wiil returns last record,and
enable the group by port it will return all the records.

Is This Answer Correct ?

0 Yes

0 No

If we are using an aggregator but forget to mention the group by port .what will be the output??..

Answer / cooldude

It will behave like a passive transformation.All the rows
are passed witout any aggregation.

Is This Answer Correct ?

8 Yes

54 No

Post New Answer