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

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

Contact data is acquired from a variety of sources. In many cases the contact data may be incomplete and not in a standardized format. Cleaning, validating and standardizing the contact data is a challenge. The goal of the Contact dimension is to have clean, valid and up-to-date data which can be used to communicate with contacts. Unfortunately, the built-in SSIS components do not provide the kind of data cleansing, validating and enhancing of demographic data that you need.

How can we clean, validate and enhance our Contact dimension without writing code?

The Melissa SSIS components are plug and play; you simply drag and drop the components onto the Data Flow and configure the component properties. There is no coding required. The Melissa SSIS components provide a wealth of capabilities including:

• SQL Server Data Import Options

• Correcting SQL Server Duplicates

• Resolving Out-of-Date SQL Server Data

• SQL Server Data Verification

Brought to you by:

Melissa-logo-320x180.jpg