Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

how many types transformations supported by sortedinput?

4 Answers  

---

EXL informatica Questions

0 Answers  

---

What do you mean incremental aggregation?

0 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

what is materialized view?

2 Answers  

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

What does cheating measurement mean?

0 Answers  

---