How do you remove duplicate records in informatica?

1 Answers  

---

What are the reusable transformations?

0 Answers   Informatica,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

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,

---

what transformations are used for Variable port?

2 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---