Answer / 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,,,,,,,,,,,,,,,,

Answer / mohanreddybank

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

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??

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

---

what is session parameters?

1 Answers   Cap Gemini,

---

How to start a workflow using pmcmd command?

0 Answers  

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

What are ETL Tools?

0 Answers   Informatica,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

How to run a session, which contains mapplet?

1 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---