Cleaning, Validating and Enhancing the SQL Server Data Warehouse Contact Dimension


(this is an on-demand video)

Sponsored by - Melissa

Webcast Abstract

Contact data is acquired from a variety of sources. You may collect contacts at trade shows or from your web site. You may purchase lists of contacts. In most cases, cleaning, validating and standardizing the contact data is a challenge.

In a SQL Server Data Warehouse, the Contact dimension includes existing customers as well as prospects. The goal of the Contact dimension is to have clean, valid, and up-to-date data which can be used to communicate with contacts via email, mail, and phone, as well as perform analysis on the contacts based on demographics. Unfortunately, the built-in SSIS components do not provide the kind of data cleansing, validating and enhanced demographic data that you need. SSIS does provide the ability for you to create script components using .NET code to do these kinds of tasks. The Melissa SSIS components are plug and play; you simply drag and drop the components onto the Data Flow, configure the component properties, and you are ready to go. There is no coding required. The Melissa SSIS components provide a wealth of capabilities including:

Since the Melissa components are available in SSIS, their capabilities are available to everyone who uses SSIS as their ETL tool.

In this session you will learn how to:

In this webcast we will demonstrate an ETL implementation for a Contact dimension in a typical data warehouse using Microsoft SQL Server Integration Services (SSIS) and the Melissa SSIS components. Join us and learn how to resolve common data quality challenges for SQL Server data warehouses.

Speaker - Ray Barley

Raymond Barley is a Business Intelligence Architect who has 15 years of experience in the design, development and implementation of ETL frameworks, data warehouses and business intelligence applications all using the SQL Server stack. He is a frequent contributor to MSSQLTips.com.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




More SQL Server Solutions












download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools