Explain in detail scd type 2 through mapping.

0 Answers  

---

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---

What is the use of code page?

0 Answers  

---

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

What all are steps in up gradation of Informatica server?

0 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---