From the course: Implementing a Data Warehouse SQL Server 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to Master Data Services (MDS) - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Introduction to Master Data Services (MDS)
- [Instructor] Rather than attempting to clean up data before it's loaded into a data warehouse, it might be better to ensure that the data is consistently entered into each of your transactional databases in the first place. This approach is known as Master Data Management. Master Data Management aims to create a single point of reference within an organization for critical data sets. The most common kinds of master data include customers or products, but it can represent any reference data that would benefit from a consistent set of permissible values. This single point of reference is then disseminated through data integration techniques to an enterprise's transactional databases, so that they're always consistent right from the start. If you were to diagram out how the master data benefits an overall business intelligence system, it might look something like this. Here we have a master database that includes all the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.