Answer / abhinaw prakash

You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

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,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

Explain about perform recovery?

1 Answers  

---

What are some examples of informatica etl programs?

0 Answers  

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

What are the features of complex mapping?

0 Answers  

---

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

3 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---