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.

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

What do mean by local and global repository?

0 Answers  

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

What is the benefit of session partitioning?

0 Answers  

---

What is polling?

1 Answers  

---

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

---