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 we do performence tuning in informatica

Answer Posted / srinu

Perf Tune is not an simple Question !!!!
its a process !!!

Performance of Informatica is dependant on the performance
of its several components like database, network,
transformations, mappings, sessions etc. To tune the
performance of Informatica, we have to identify the
bottleneck first. Bottleneck may be present in source,
target, transformations, mapping, session, database or
network.
Identify bottleneck in Source
Identify bottleneck in Target
Identify bottleneck in Transformation
Identify bottleneck in sessions
DATABASE OPTIMISATION
OPTIMUM CACHE SIZE IN LOOKUPS


so and so,,,,,,,,,,,,,,,,

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

EXL informatica Questions

1310


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

970


Explain load alternative records / rows into multiple targets - informatica

1099


what is Active lock explain

2727


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1926


What is the use of an aggregator cache file?

1140


Clarify the utilization of aggregator cache record?

943


What is an aggregator transformation?

1030


What is the function of look up transformation?

1054


What do you mean by enterprise data warehousing?

1002


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2181


What is joiner transformation?

948


What is data movement mode in Informatica and difference between them?

1057


What if the source is a flat-file?

1042


What is session task and command task?

1177