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
- 4460 Views
- I also Faced
- E-Mail Answers
What is staging area?
when we go for unconnected lookup transformation? and why?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
What happens when a session fails and you click on recover?
what is the difference between lookupoveride and joiner?
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????
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What are the diffrences between joiner transformation and source qualifier transformation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What is the scenario which compels informatica server to reject files?
daily how much amount of data send to production?
Teradata 
