we r using aggregator with out using groupby?
- 7 Answers
- 20922 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / naresharavetis
if u use aggregator t/r without using group by function u
get one summirized result but group by option allows u get
deatil result.
for example .without using groupby u want see a releince
store sales .u will get sales of whole store but when uuse
group by u get imtemized sales result
storecode itemname sales
101 vegetable 500
101 vegetables 700
101 electronics 5000
101 electronics 10000
101 cooldrinks 200
101 cooldrinks 500
result without groupby: store sales:17400
result with groupby: vegetables sales :1200
electronics sales: 15000
cooldrinks sales: 700
| Is This Answer Correct ? | 4 Yes | 19 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Why filter transformation is an active one?
What is the difference between source qualifier transformations source filter to filter transformation?
What are multi-group transformations?
Define filter transformation?
What is complex mapping?
What are junk dimensions?
What are the types of schemas we have in data warehouse.
design of staging area?
What is dimensional table? Explain the different dimensions.
What is a joiner transformation and why it is an active one?
server hot-ws270 is connect to Repository B. What does it mean?
Partition, what happens if the specified key range is shorter and longer
explan ur project architecture?
