I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

Explain the types of transformations?

0 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---