Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

what is lookup chache?

1 Answers   Patni,

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---