Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 Help Members By Posting Answers For Below Questions

Please let me know how to make Data masking in informatica..

1663


What is parallel processing in informatica?

1619


What is lookup change?

986


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031


Scheduling properties,whats the default (sequential)

1891


What is sq transformation?

1080


what is song in infrmatica...?

2162


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

2063


What is a code page?

1115


Different sorts of metadata that stores in the storage facility?

947


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1865


Which transformation is needed while using the Cobol sources as source definitions?

1124


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1908


Explain informatica architecture - version 8 / 9

1021


To import the flat file definition into the designer where should the flat file be placed?

1004