Category Archives: ETL

Metadata Mart the Road to Data Governance

Posted on December 9, 2014 by irawarrenwhiteside

 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

Posted in Data Governance, data profiling, Dimensional Model, ETL, Guerilla MDM, Kimball ETL (subsystem 1), Metadata Mart, Uncategorized | Tagged , , , | 2 Comments

Self Service Semantic BI (Business Intelligence) Concept

Posted on December 8, 2014 by irawarrenwhiteside

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 →

Posted in Big Data, Data Governance, data profiling, ETL, Mdm, MDS, MDS Stored Procedures, Metadata Mart, Self Service Semantic BI, SSIS | Tagged , , , , , , , , , | Leave a comment

Mastering Microsoft SQL Server tools required for EIM (MDS, DQS, Profiling and SSIS) – Complete Kit

Posted on April 23, 2014 by irawarrenwhiteside

  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 →

Posted in data profiling, ETL, Extreme Scoping Agile SCRUM, Fuzzy Matching, Mdm, Metadata Mart, SSIS, Uncategorized | 1 Comment

Fast, Data Driven Netezza Load – The Prittie Good Approach

Posted on November 28, 2012 by irawarrenwhiteside

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 →

Posted in Big Data, data profiling, ETL, Metadata Mart, SSIS | Tagged , , , , | Leave a comment