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...

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?

Please answer below. thank you.

Answer Posted / sai

There is no performance difference while aggregation because Order by always comes after Aggregation.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1532


Explain in detail about scd type 1 through mapping.

1327


Enlist the tasks for which source qualifier transformation is used.

1001


What is the maplet?

1066


What is informatica worklet?

1001


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1072


Explain the different kinds of facts.

948


What are the performance considerations when working with aggregator transformation?

1119


Define mapplet?

981


can u any challenge your project?

1984


design of staging area?

1984


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7360


What is the command used to run a batch?

1018


How can we remove the duplicates from flat file source?

972


In how many ways we can create ports?

1083