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 parallel processing in informatica?

0 Answers  

---

Write the advantages of partitioning a session?

0 Answers  

---

how to convert the .doc docs into .txt format using informatica

4 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

What is the Hierarchy of DWH?

1 Answers  

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---

What is a stored procedure transformation?

0 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---