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
EXL informatica Questions
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??
Explain load alternative records / rows into multiple targets - informatica
what is Active lock explain
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the use of an aggregator cache file?
Clarify the utilization of aggregator cache record?
What is an aggregator transformation?
What is the function of look up transformation?
What do you mean by enterprise data warehousing?
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
What is joiner transformation?
What is data movement mode in Informatica and difference between them?
What if the source is a flat-file?
What is session task and command task?