Answer / venkateshmalneni

by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it


in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target

Answer / mahaboob basha

connot delete the duplicate records while using filter t/r

Answer / devendar pd

if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.

I think we can't remove duplicates only by using filter

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

What are the different threads in DTM process?

1 Answers  

---

How many ways you create ports?

1 Answers  

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

What is power center repository?

1 Answers  

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---