Interested to Buy Any Domain ? << Click Here >> for more details...
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!
- 1 Answers
- 4427 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
Is it possible to revert a global repository to local one and why?
Can anyone tell me the new features in Informatica 9 Version?
What could be the possible resons of locks by user?
how to load dimension table and fact table. plz tell me the steps.
Enlist few areas or real-time situations where informatica is required.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
In informatics server which files are created during the session rums?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What does cheating measurement mean?
What are junk dimensions?
What is the difference between Active and Passive transformation?
Does an informatica transformation support only aggregate expressions?
What is DR strategy for Informatica project?
What is InformaticaPowerCenter?
Differences between version 7.x and 8.x.
