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 is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

---

What is InformaticaPowerCenter?

0 Answers   Informatica,

---

what is the difference between stop and abort

2 Answers  

---

COM components can be used in Informatica

0 Answers  

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

How many transformations can be used in mapplets.

0 Answers  

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

How to start a workflow using pmcmd command?

0 Answers  

---