we r using aggregator with out using groupby?
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
Please let me know how to make Data masking in informatica..
What is parallel processing in informatica?
What is lookup change?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Scheduling properties,whats the default (sequential)
What is sq transformation?
what is song in infrmatica...?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a code page?
Different sorts of metadata that stores in the storage facility?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Which transformation is needed while using the Cobol sources as source definitions?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain informatica architecture - version 8 / 9
To import the flat file definition into the designer where should the flat file be placed?