DQS has the ability to interact with other data movement components: SSIS and Master Data Services (MDS). There is a DQS cleansing component in SSIS that provides a connection to a knowledge base. This component will create a cleansing project for the incoming data stream and will apply the Knowledge Base in the DQ server to the data stream and generate the result. There is also a functionality to apply matching rules on the data in an Excel spreadsheet before loading that data into MDS. In this section, we will explore how to use the interaction of DQS with MDS and SSIS.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By :
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By:
Overview of this book
Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Data Warehouse Design
SQL Server Analysis Services Multidimensional Cube Development
Tabular Model Development of SQL Server Analysis Services
ETL with Integration Services
Master Data Management
Data Quality and Data Cleansing
Data Mining – Descriptive Models in SSAS
Identifying Data Patterns – Predictive Models in SSAS
Reporting Services
Dashboard Design
Power BI
Integrating Reports in Applications
Index
Customer Reviews