how to delete duplicate records by using filter
transfermation?
Answers were Sorted based on User's Feedback
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 |
Answer / mahaboob basha
connot delete the duplicate records while using filter t/r
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
Is there any target staging area in informatica not staging area
What are the different threads in DTM process?
How many ways you create ports?
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?
have u done any performance tuning? how u ll do?
Why sorter is an active transformation?
What is power center repository?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What is different between informatica version 8 and 9 version
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
what is difference between mapping and mapplet ?
Can we insert ,update ,delete in target tables with one update strategy tran.?