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 / swetha

Use sorted input.

The aggregator stores data in the aggregate cache until it
completes aggregate calculations. When u run a session that
uses an aggregator transformation, the informatica server
creates index and data caches in memory to process the
transformation. If the informatica server requires more
space, it stores overflow values in cache files.

Is This Answer Correct ?    13 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1891


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1216


Performance tuning in UNIX for informatica mappings?

2505


Explain the tuning lookup transformation - informatica

950


Explain load alternative records / rows into multiple targets - informatica

1098


Write the unconnected lookup syntax and how to return more than one column.

1048


What is a repository manager?

1026


Where are the source flat files kept before running the session?

1010


How to create the source and target database connections in server manager?

1033


hi real timers . iam waiting for ur reply regarding ETL TESTING

2206


What do you mean by enterprise data warehousing?

1002


Differentiate between sessions and batches?

962


How can we delete duplicate rows from flat files?

1161


Explain the code page compatibility?

1021


What are ETL Tools?

1039