In a simple mapping when i use aggregate t/r with out any condition or group b

In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?

Question Posted / srinivas.medagum

4 Answers
6729 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting outp..

Answer / srinivas.medagum

When the records come from SQ each record from first one
checks for the group by port but till last record it doesnot
found .So by default as the last record considered as only
record it stores in Agg T/R.

Is This Answer Correct ?

3 Yes

1 No

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting outp..

Answer / ankit kansal

By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...

please make me correct if i am wrong..

http://deepinopensource.blogspot.in

Is This Answer Correct ?

1 Yes

0 No

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting outp..

Answer / naresh_infa96

If you're using Aggregator Trasnformation without using group by on any port then the aggreagtor TXNs consider whole table as one group and gives the last row as output.

Why last row as Output : by default aggregator uses MAX() function

Is This Answer Correct ?

0 Yes

0 No

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting outp..

Answer / pooja

few options:
1. did you place any other trans before Agg t/r
2. check how many rows are comming form source.
3. run the debuger for more info

Is This Answer Correct ?

0 Yes

1 No

Post New Answer