IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. I

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????

Question Posted / anirvin2009

3 Answers
6822 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / prathap

IF GROUPBY IS NOT SELECTED INFORMATICA SERVER UNDERSTANDS WHOLE TABLE AS A ONE GROUP AND ITS GIVE LAST RECORD OUT

Is This Answer Correct ?

2 Yes

1 No

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / amedela chandra sekhar

Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.

Is This Answer Correct ?

4 Yes

5 No

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / amedela chandra sekhar

when u want to perform calculations on groups u can go for
aggregator t/r.aggregate functions like
min,max,last,first,count ...

if u are not selected groupby the integration service returns
last record from all input rows.

why means that integration service rule.

Is This Answer Correct ?

3 Yes

7 No

Post New Answer