My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

What is intricate mapping?

0 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

COM components can be used in Informatica

0 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

performance tuning of Informatica

1 Answers  

---