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
What are the issues you have faced in your project? How did you overcome those issues?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are Dimensional table?
what is $$$$?
What are the performance considerations when working with aggregator transformation?
What are session parameters ? How do you set them?
What are the databases that informatica can connect to windows?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Performance tuning in UNIX for informatica mappings?
What are the mapping parameters and mapping variables?
What is Data Caches size?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Differentiate between a repository server and a powerhouse?
How to join three sources using joiner?