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

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

What is meant by a domain?

0 Answers  

---

Explain the flow of data in Iinformatica?

1 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

What is the function of union transformation?

0 Answers  

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---