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 can yoU improve session performance in aggregator
transformation?

Answer Posted / srikanth

hi haritha

u r correct

For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.

we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a query to retrieve the latest records from the table sorted by version(scd)

1115


Explain lookup transformation source types in informatica

1151


How can you differentiate between powercenter and power map?

1140


What is the benefit of partitioning a session?

1235


What is persistent lookup cache?

1096


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1179


What is a sorter transformation?

1156


What is data transformation manager process?

1221


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1141


What are roles and groups and benefits of using them?

1103


can u any challenge your project?

2084


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2113


What is the need of an ETL tool?

1158


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

1125


What are junk dimensions?

1112