webcast signup header

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

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.

Webcast Date

Thursday, November 21, 2019
3:00:00 PM EST | 8:00:00 PM UTC


presenter 1
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.

Sponsored by

sponsor logo

Register for this webinar:

First Name*

Last Name*

Business Email*


Org Address*

Org City*

Org State

Org Postal Code*

Org Country*

Org Phone*


Job Title*

# of SQL Servers*

Organization Size*

SMS reminder
carrier: number: (5551234567)

Save My Details

Register me for these webinars too:

Taming the beast: How to manage SQL Server Agent Jobs
Tuesday, November 19, 2019 - 3:00:00 PM EST
Speaker(s): Eric Blinn and Robert Newman - Sponsor: MVP Systems

Avoiding the Next Cloud Outage - Keeping SQL Server Up and Running through Disaster
Friday, November 22, 2019 - 1:00:00 PM EST
Speaker(s): Dave Bermingham - Sponsor: SIOS

Right-Sizing Your Cloud Consumption on AWS
Tuesday, December 10, 2019 - 11:00:00 AM EST
Speaker(s): Kevin Kline, Denis McDowell and Tom Staab - Sponsor: SentryOne

Signup for our newsletter

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.



Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.