Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Incremental data load for Fuzzy Grouping transform

Author  Topic 

pankajbose
Starting Member

1 Post

Posted - 2008-11-19 : 12:55:00
Hi,

I am looking for a way to do incremental data loading for Fuzzy Grouping tranformation. I have a data set (person name and address) of around 2 mil records, on which I run the Fuzzy Grouping transformation to find similar records. Now as new data keeps adding, I would like to match the new record against existing groups and place in suitable groups if a fuzzy match found. I don't want to run the batch Fuzzy Grouping transformation every time a (some) records are added.

Appreciate any one helping me with some suggestions to accomplish this.

Thanks
Pankaj
   

- Advertisement -