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
- 3718 Views
- I also Faced
- E-Mail Answers
What does update strategy mean, and what are the different option of it?
what are presession,postsession success and postsession failure commands ?
Enlist the various types of transformations.
scenario
What is the benefit of session partitioning?
What is dimensional table? Explain the different dimensions.
what is the gap analysis?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What is difference between a connected look up and unconnected look up?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
How many number of sessions can one group in batches?
Teradata 
