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  

---

Which kind of index is preferred in DWH?

2 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

What is Index Caches size?

0 Answers   Informatica,

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

Define joiner transformation?

0 Answers  

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---