Data Quality and Comparison Components in the SSIS Productivity Pack скачать в хорошем качестве

Data Quality and Comparison Components in the SSIS Productivity Pack

The Data Quality and Comparison is a grouping of SSIS add-on components from the SSIS Productivity Pack which help developers have consistent, clean data. There are currently 2 components within this category: Diff Detector: Enables the comparison of two sources; a primary and a secondary source. Rows from the inputs are matched using a primary key (simple or compound key) and compared to each other to determine if the rows are unchanged, changed, deleted from the primary data source, or added to the secondary data source. Duplicate Detector: Compares rows within a data source to identify duplicate rows based on an approximate (Fuzzy) or exact match. The component creates two outputs: Unique Rows and Duplicate Rows. The Duplicate Rows output has 4 additional fields: Richness Score, Richness Rank, Similarity Score, and GroupID. You can learn more about these components from the help manual: https://www.kingswaysoft.com/products... The components along with all others found within the SSIS Productivity Pack are available for download here: http://www.kingswaysoft.com/products/... Visit the following link to learn more about the SSIS Productivity Pack, a collection of premium, powerful and unique SSIS components every developer needs in their toolbox: https://www.kingswaysoft.com/products... This video was made with v4.0 of the SSIS Productivity Pack