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.
Thursday, November 21, 2019
3:00:00 PM EST | 8:00:00 PM UTC
Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.