How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

what is the size of your data warehousing?

0 Answers   IBM,

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

How to generate sequence numbers?

0 Answers  

---

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

2 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---