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

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

What is informatica powercenter repository?

0 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

What is DR strategy for Informatica project?

0 Answers  

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

How to do unit testing in informatica?

0 Answers  

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What is an expression transformation?

0 Answers  

---