What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

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,

---

What is an unconnected transformation?

0 Answers   Informatica,

---

---

connected and unconnected lookups?

4 Answers  

---

What is parallel processing in informatica?

0 Answers  

---

What is the target load order?

3 Answers   HCL, Informatica,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---