Answer / karthik

You can increase the loading of query faster in following ways:

Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

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

1 Answers  

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

How to use Normalizer transformation?

2 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

What are the types of caches in lookup? Explain them.

0 Answers  

---