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

How to improve the performance of Aggregate
transformation?

Answer Posted / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2189


What is Session and Batches?

1155


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847


Explain what are the different versions of informatica?

1145


How are the sources and targets definitions imported in informatica designer?

1170


What is fact table? Explain the different kinds of facts.

1126


What is meant by a domain?

1189


Can anyone tell me the new features in Informatica 9 Version?

2214


What are the features of complex mapping?

1209


tell me 5 session failure in real time how can you solve that in your project?

2392


How do you take back up of repository?

1209


What is expression transformation?

1146


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1990


Enlist the various types of transformations.

1122


what is INFORMATICA TESTING process

2334