Creating Reference Tables from Profile Columns Overview
A reference table contains reference data that you can use to standardize source data. Reference data can include valid and standard values. Create reference tables to establish relationships between source data values and the valid and standard values.
You can create a reference table from the results of a profile. After you create a reference table, you can edit the reference table to add columns or rows and add or edit standard and valid values. You can view the changes made to a reference table in an audit trail.
Story
HypoStores wants to profile the data to uncover anomalies and standardize the data with valid values. You are the analyst who is responsible for standardizing the valid values in the data. You want to create a reference table based on valid values from profile columns.
Objectives
In this lesson, you complete the following tasks:
- 1. Create a reference table from the CustomerTier column in the Profile_LA_Customers_Custom profile by selecting valid values for columns.
- 2. Edit the reference table to configure different valid values for columns.
Prerequisites
Before you start this lesson, verify the following prerequisite:
- •You have completed lessons 1 through 6 in this tutorial.
Timing
Set aside 15 minutes to complete the tasks in this lesson.