how we do performence tuning in informatica

Question Posted / phanimohan.k

3 Answers
6831 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how we do performence tuning in informatica ..

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

how we do performence tuning in informatica ..

Answer / mohanreddybank

First we need to identify the bottlenecks,
Then we need to do peer review

Is This Answer Correct ?

1 Yes

0 No

how we do performence tuning in informatica ..

Answer / karthik

Guys we know the bottle necks, but pls tel us how do we
resolve it..

for example :

if source is reading the date very slowly, how do we solve
that??

Is This Answer Correct ?

0 Yes

0 No

Post New Answer