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 is facttable granularity?

2 Answers  

---

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

0 Answers   Wipro,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

What is A cache?

2 Answers  

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

What is A complex mapping?

3 Answers   TCS,

---

How to load relational source into file target?

3 Answers   IBM,

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---