Click the 'Add Filter' button to add one. When a new duplicate detector component is added, it will not have any filters. The General page of the Diff Detector Component allows you to specify the general settings of the component. The component includes the following three pages to configure how you want to read data. Comparisons can be either exact or approximate (fuzzy).Įach row is compared to other rows based on the specified filters, is determined to either be unique or a duplicate and is directed to the applicable output. Comparison filters can be added for fields in the source that determine how they will be compared. But compared to other tools it returns a pretty large sum.The Duplicate Detector component is an SSIS data flow pipeline component that can be used to compare rows within a single data source and identify duplicate rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |