Example: Data Migration Specification
This example shows key sections from a Data Migration Specification artifact. It includes an introduction describing the scope of the migration, data profile information, and an excerpt from a data mapping table.
Relationships
Related Elements
Main Description

Scope of the Migration

The Common View Customer Management System will merge three existing customer relationship management and marketing systems. This Data Migration Specification describes the one time transfer of data from the Reservations, Gift Shop, and Marketing databases to the Common View Customer Management System database.

This document defines, at a database level, the fields which will be migrated to the Common View Customer Management System database to ensure all data is loaded correctly.

Data Profile

Source Data Systems

Reservations Database

Reference the Data Dictionary (DocID: KCR-135)

Gift Shop

Reference the Physical Data Model (DocID: KCGS-145) and Use Case Model (DocID: KCGS-75)

Marketing

Reference the Physical Data Model (DocID: KCM-145) and the Logical Data Model (DocID:KCM-125)

Data Attributes Profile and Dependencies

Reference output reports from WebSphere ProfileStage in the appendix of this document.

Data Mapping Table

Marketing



Target Table/ File Target Column/Data Element Data Type Len Target Column/Data Element Description Source System Source Table/ File Source Column/Data Element Data Transfer Rules
Customer ID Numeric 9 Primary identifier for customer Marketing Customer Reference Database CUST_NO Enforce uniqueness. Reject all customers with a customer number beginning with '55'.
Customer NAME Character 25 Format of name is a single character string, which can include businesses as well as individuals. Marketing Customer Reference Database CUST_NAME Use client formatting module(s) to validate format of customer name. Log all errors and reject record.
Customer CREDIT_LIMIT Numeric 7 This is an amount field in whole dollars. Marketing Customer Reference Database CREDIT_AMT Remove cents from source field. Move whole dollars only.
Customer FIRST_CONTACT_DATE Date    Date customer made first contact. Marketing Customer Reference Database CONTACT Date format in source is incorrect - need to make year four positions.
Customer PURCH_NUMBER Numeric 4 The total number of purchases customer has made since the first contact date. Marketing Customer History Database See rules Need to count all of the purchase records in the Customer History Database for each customer number and place the total count in this target field.
Customer PURCH_VALUE Numeric 7 This is an amount field in whole dollars. Marketing Customer History Database See rules Need to aggregate the purchase amounts in all of the purchase records in the Customer History Database for each customer number and place the total amount in this target field.