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 |
complex mapping ur project u r invlve can u explain and give real time example give me ?
i have 2 session s1 execute s2 load first session fail what is the reason?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
how can one eliminate dupliacte data with out using distinct option?
Can we insert ,update ,delete in target tables with one update strategy tran.?
What are teh different tasks that can be created in workflow manager?
what are challenges that you faced in testing? give solution to it?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
how tokens will generate?
what is SDLC way of code development?
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
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