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 do you convert single row from source into three rows into target?
Global and Local shortcuts. Advantages.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
In development project what is the process to follow for an etl developer from day1
What is target load order?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What all are steps in up gradation of Informatica server?
What are the advantages of using informatica as an etl tool over teradata?
What is meant by a domain?
How to load the data from a flat file into the target where the source flat file name changes daily?
waht type of interface is used for testing the data in informatica
What is expression transformation?
How would you copy the content of one repository to another repository?
How to open an older version of an object in the workspace?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
