Another important fact in designing a data warehouse is which data to conform and how to conform the data. For example, one operational system feeding data into the data warehouse may use "M" and "F" to denote sex of an employee while another operational system may use "Male" and "Female".
Though this is a simple example, much of the work in implementing a data warehouse is devoted to making similar meaning data consistent when they are stored in the data warehouse.
Typically, extract, transform, load tools are used in this work.
Master Data Management has the aim of conforming data that could be considered "dimensions".
No comments:
Post a Comment