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 is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---

Whats the difference between $, $$, $$$

9 Answers  

---

How is union transformation utilized?

0 Answers  

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

Explain what are the different versions of informatica?

0 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

what is lookup ?

7 Answers  

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---