Category Archives: SSIS

Merry Christmas Data Classification, Feature Engineering , Data Governance. ‘How to’ do it and some code take a look

Posted on November 30, 2021 by irawarrenwhiteside

Therefore I decided, to update some of the techniques and code patterns, I’ve used in the past regarding the information value chain and or record linkage , and we are going to make the results available with associated business and code examples initially with SQL Server and data bricks plus python Continue reading →

Posted in agile, Awarement, Big Data, blocking index, Data Governance, data profiling, data quality, data quality mart, Dimensional Model, Download Complete Data Profiling Kit - TSQL, ETL, extreme scoping, Extreme Scoping Agile SCRUM, Fuzzy Matching, Guerilla MDM, Guerilla MDS, Ira Whiteside, Machine Learning, Master Relationship Management, Mdm, Metadata Mart, MRM, Self Service Semantic BI, serverless, SQL Saturday, SQL Server Central, SSIS, stroke, Table Variable TSQL, Uncategorized | Tagged , , , , , , , | Leave a comment

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

Microsoft BI Stack Leveraged with Vendor Add – In’s for Data Quality and Data Lineage.

Posted on October 24, 2012 by irawarrenwhiteside

Lineage as it applies to data in Business Intelligence provides the capability see track back where data came from. Essentially it supports “Metric Decomposition” which is a process for breaking down a metric (business calculation) into separate parts. With this capability you can determine your data’s ancestry or Data DNA. Continue reading →

Posted in Awarement, Computers and Internet, data profiling, Donal Farmer, Extreme Scoping Agile SCRUM, Fuzzy Matching, Ira Whiteside, Kimball ETL (subsystem 1), MelissaData, Metadata Mart, SSIS, Uncategorized | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

SQL Saturday New York #158

Posted on August 11, 2012 by irawarrenwhiteside

Last Saturday August 4, 2012 we attended SQL Saturday #158 in New York. We (Tessie, Victoria and Brandon) were there educating folks on SSIS Data Quality for Melissa Data. For Actuality Business Intelligence and Melissa Data the event planning staff … Continue reading →

Posted in Computers and Internet, Ira Whiteside, MelissaData, SQL Saturday, SSIS, Tessie Whiteside, Uncategorized | Leave a comment

Carlier John Lauer 1963 – 2011

Posted on December 7, 2011 by irawarrenwhiteside

I’d like to offer our prayers, remembrance and celebrate the life and friendship of Carlier John Lauer. John passed away yesterday morning. Ira & Tessie

Posted in SSIS | Tagged , | Leave a comment

SSIS Dynamically Map Column Data Based on Column Pattern Profiling

Posted on January 28, 2010 by irawarrenwhiteside

SSIS Dynamically Map Column Data Based on Column Pattern Profiling Problem The problem set here is what to do when faced with an input file that has columns with multiple types of content(Domains). For instance a single column may contain … Continue reading →

Posted in SSIS | Leave a comment