What are parallel querys and query hints?

1 Answers  

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

What is the function of union transformation?

0 Answers  

---

What is a mapplet/worklet in informatica?

0 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---