My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

In target table how to display the system time

1 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---