Interested to Buy Any Domain ? << Click Here >> for more details...
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain load alternative records / rows into multiple targets - informatica
How an expression transformation differs from aggregator transformation?
Explain sessions and how many types of sessions are there?
Write the advantages of partitioning a session?
Why union transformation is an active transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is DR strategy for Informatica project?
What are the modules in Power Center
What are the types of lookup transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How might you approve all mappings in the archive all the while?
Mention some types of transformation?
What is an Integration service in Informatica?
