
Explore data cleansing operations by building a data cleansing project in data quality services, using a knowledge base and cleansing activities to correct spellings, standardize country names, and manage duplicates.
Create and apply matching policies to identify duplicates across country, city, address, coordinates, and hotel name, using prerequisites and exact vs similar matching to score and remove duplicates.
Launch a deduplication project within a data quality framework, apply matching policies, and use survivorship rules such as most complete and longest record to remove duplicates and export results.
Manage data quality projects and knowledge bases by opening, deleting, renaming, locking, and exporting or importing domains and knowledge bases; edit domain values and publish updates.
The topics which are covered in this online video training course on DQS are
DQS Introduction
DQS Terminologies
DQS Architechture
DQS Installation
Data Cleansing
Data Source used for Demonstration
Domains and Knowledge Base
Cleansing Project
SSIS Package for Data Cleansing
Data Deduplication
Matching Policies
Deduplication Project
Advanced DQS
Term Based Relations
Composite Domains
Creating Regular Expressions Rules in a domain
Domain DataTypes
Import Knowledge Base & Domains
Export Knowledge Base & Domains
Open Delete Rename Unlock Knowledge Base & Projects
Purpose of each DQS Databases
Backup and Restore DQS Databases
DQS Configurations
DQS Activity Monitor