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
How can we handle two sessions in informatica?
what is the Default Source Option For Update Strategy Transformation?
Explain in detail about scd type 1 through mapping.
r u done any partitions in ur project?
How to generate or load values in to the target table based on a column value using informatica etl tool.
tell me the rules and responsblites in our project(my project is development)
What is informatica metadata and where is it stored?
How can we delete duplicate rows from flat files?
can you please explain me pre session and post session options?
where to store informatica rejected data?
design of staging area?
what is $$$$?
What is blocking transformation?
can u any challenge your project?
What is a joiner transformation and why it is an active one?