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 we use informatica in our project?

2 Answers   TCS,

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

why we use stored procedure transformation?

4 Answers   IBM,

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Briefly define reusable transformation?

0 Answers  

---

What is DTM process?

4 Answers  

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---