November 19, 2010 at 11:15 am
parthi-1705 (11/19/2010)
hiI have used the Source ---->derived column and unionall ---->Destination it has run sucessfully.i need to check duplicates in this ,that is i need to find the duplicate record in the table with the incoming record
for eg: if client1 emp1 record is already in the table i should not insert into table rest of the data need to be inserted which transformation i need to use. whether i can use Fuzzy grouping transformation if so how(how does the fuzzy grouping can be implimented here)
Don't use a Fuzzy grouping. Use a lookup component or if you must a merge join (preferably not). But I would use a plain old T-SQL statement with a left outer join.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply