Speaking of the keys to managing data in data warehouse projects is to do Master Data Management (MDM). The MDM is a key step in the integration processes to meet the need of unifying, essential in the analytic world. We can not forget that, ultimately, they are collecting data from two different systems. The MDM manages minimize duplication errors, analysis and manage the unique vision in business.
The Master Data Management is an implicit stage to the ETL, to its integration process; and it is carried out in the staging area, as a further process of transformation.
Unification of sources and Master Data Management: the keys to managing data in data warehouse projects
In data warehouse environments, the MDM is a critical practice in the treatment of the master tables or shaped dimensions. The stringency of unifying the various sources of the same element of business is a key success factor and therefore, the master data management becomes transparent dispersion of the master data in different applications, as found in the analytic world. This is achieved thanks to:
• Cancels redundant information.
• Avoid different procedures for the maintenance of teachers (as the absence of centralized management teams).
• Frequency minimizes manual intervention (ending leading to errors and needing adjustments, etc.).
• Cancels the absence of procedures that provide unified view and / or global.
• Elude inconsistent information systems with aggregate or consolidated information (originating data quality issues).
• Avoid duplication of information collection procedures.
• Minimize the operational risk in the analytical environment.
Considering that the aim must be to achieve a single view of the truth, to provide unified management of the pillars of the business is the way to go, and can only be explored when the management of master data is effective and responds to a strategy and integration as described.