Aggr transformation returns last row of each block or each group. So here

Hello,

I have the below table:

CityID CityName CostOfLiving
1 Mumbai 5000
1 Bangalore 4500
1 Chennai 4800
2 Vapi 6000
3 New Delhi 8000

I am passing the rows of the above table through the
aggregator transformation in Informatica

What happens in the following conditions:
1) I specify no group-by ports?
2) I specify a group-by on CityID without making any
separate post for aggregation? Which city and costofliving
will this eventually take for CityID=1?
3) Rest being same as point 2,I take the sum of cost of
living.Which city will be returned for ID=1?

Thanks for your help!

Question Posted / kapil

1 Answers
4356 Views
I also Faced
E-Mail Answers

Answer Posted / kapil

Aggr transformation returns last row of each block or each
group. So here are the ans
Output of Case 1)
3 New Delhi 8000

Output of Case 2)
1 Chennai 4800

Output of Case 3)
1 Chennai 14300

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What the difference is between a database, a data warehouse and a data mart?

1159

What is domain and gateway node?

1171

Separate from an archive server and a powerhouse?

965

What is persistent lookup cache?

1037

Where can we find the throughput option in informatica?

1065

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2073

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?

10179

What are the settings that you use to configure the joiner transformation?

1055

What is a mapplet/worklet in informatica?

1192

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1067

Explain pmcmd command usage in informatica

1140

What is informatica etl tool?

1003

How many types of sessions are there in informatica.please explain them?

1171

Mention few power centre client applications with their basic purpose?

956

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1061