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
- 4263 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
Briefly describe lookup transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Describe data concatenation?
How to improve the performance of a session using sorter transformation?
Write the prerequisite tasks to achieve the session partition?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the main features of Oracle 8i with context to datawarehouse?
Explain sessions?
What are the types of presistent cache in look up tr.
What is difference between a gateway node and worker node?
What is target load order?
whats the logic to load the lower level of granularity of data to fact table.
What are the different options available for update strategy?
Explain the different kinds of facts.
what is degenerated dimension?
