Category Archives: SSIS

Fast, Data Driven Netezza Load – The Prittie Good Approach

Posted on November 28, 2012 by

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

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

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

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

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