Category Archives: Metadata Mart
Organic Data Quality vs Machine Data Quality
Awarement of data quality issues is business as usual, awarement of specific data quality is enlightenment. Continue reading →
Metadata Mart the Road to Data Governance
or Guerilla Data Governance Implementing a Metadata Mart the Road to Data Governance best viewed in PRESENTATION Mode, there is animation. This presentation has narrative, play in presentation mode with sound on. https://onedrive.live.com/redir?resid=E7059817CA5789D0!10028&authkey=!AE6eWl-gzh2mq_M&ithint=file%2cpptx
Self Service Semantic BI (Business Intelligence) Concept
The key is to link source data in the Enterprise via a Business Vocabulary from MDM to the Source Data Metadata Vocabulary from a Metadata Mart to conform the triples collected internally and externally. Continue reading →
Mastering Microsoft SQL Server tools required for EIM (MDS, DQS, Profiling and SSIS) – Complete Kit
Overview Understanding and mastering the various Microsoft SQL Server Tools available for Data Quality , Master Data Management , Fuzzy Matching and Enterprise Information Management can be daunting and exasperating. In the hopes of reducing the anxiety and … Continue reading →
Guerilla MDM via Microsoft MDS: Force Model Validation or TSQL Script to force set Validation Status ID ‘s
Using Metadata and code generation to programmatically set Validation Stats for all leaf members in an MDS Entity. Continue reading →
Agile MDM Data Modeling and Requirements incorporating a Metadata Mart.(Guerilla MDM)
Recently an acquaintance of mine asked about my thoughts on the approach for creating a MDM data model and the requirements artifacts for loading MDM. I believe with this client and with most clients that the first thing that we … Continue reading →
Fast, Data Driven Netezza Load – The Prittie Good Approach
A few years ago I have a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would … Continue reading →
