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.

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---

lookup transformation with screenshots

0 Answers   TCS,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

how can we calculate fact table size?

1 Answers  

---

Explain about perform recovery?

1 Answers  

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---