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
Tell me about Propagate functions in informatica
How can we update a record in the target table without using update strategy?
Global and Local shortcuts. Advantages.
What are the different components of powercenter?
How do you load first and last records into target table?
Enlist the various types of transformations.
What are Dimensional table?
What is the need of an ETL tool?
What is meant by lookup transformation?
If informatica has its scheduler why using third party scheduler?
Enlist the tasks for which source qualifier transformation is used.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what are the deliverables?in your project?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How will the document be delivered to me?