how to delete duplicate records by using filter
transfermation?

Answers were Sorted based on User's Feedback



how to delete duplicate records by using filter transfermation?..

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

Is This Answer Correct ?    5 Yes 1 No

how to delete duplicate records by using filter transfermation?..

Answer / mahaboob basha

connot delete the duplicate records while using filter t/r

Is This Answer Correct ?    2 Yes 1 No

how to delete duplicate records by using filter transfermation?..

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 This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

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,


Categories