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

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


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

2 Answers   Zensar,


What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,


what are challenges that you faced in testing? give solution to it?

1 Answers  


What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  


how tokens will generate?

0 Answers  


what is SDLC way of code development?

0 Answers  


Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,


Categories