Creating Reference Tables 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 the source data values and the valid and standard values.
You can manually create a reference table using the reference table editor. Use the reference table to define and standardize the source data. You can share the reference table with a developer to use in Standardizer and Lookup transformations in the Developer tool.
Story
HypoStores wants to standardize 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 to define standard customer tier codes that reference the LA customer data. You can then share the reference table with a developer.
Objectives
In this lesson, you complete the following task:
- •Create a reference table using the reference table editor to define standard customer tier codes that reference the LA customer data.
Prerequisites
Before you start this lesson, verify the following prerequisite:
- •You have completed lessons 1 and 2 in this tutorial.
Timing
Set aside 10 minutes to complete the task in this lesson.