Home
Lookup Tables
Lookup tables and its usage. Data Normalization tables and Universal Name tables. Information about tasks related to lookup table, and importing data into a lookup table.
Introduction to Lookup Tables

Welcome
Explore standardizing terms, Identifying and removing duplicate records, Identifying and grouping related records, Incorporating manual review into the data quality process.
Getting Started
Learn Data Quality capabilities—Parsing, Standardization, Matching, Deduplication, Review of Exception Records.
Parsing
Know-how of types of parsing. Analyze parsing results.
Standardization
Standardize terms and personal names, and explore templates for standardization.
Matching
Learn about matching terminologies, standard fields in matching tasks, match rules, matching records, universal matching service, express match key, analyzing match results, and dataflow templates for matching.
Deduplication
Remove duplicate records either by using filtering or by merging data from groups of duplicate records into a single record.
Exception Records
Manage exception records. Design a dataflow for validating exception records in real-time.
Lookup Tables
Lookup tables and its usage. Data Normalization tables and Universal Name tables. Information about tasks related to lookup table, and importing data into a lookup table.
Data Stewardship Portal
Configure Data Stewardship settings.
Accessing Stages in Enterprise Designer
Access stages for Advanced Matching, Data Stewardship, Data Normalization, and Universal name.
Performance Tuning
Tips to improve performance of data quality stages for Advanced Matching, Data Normalization, and Universal Name.
ISO Country Codes and Module Support
Lists the ISO codes for each country as well as the modules that support addressing, geocoding, and routing for each country.

Introduction to Lookup Tables

A lookup table is a table of key/value pairs used by Spectrum Technology Platform stages to standardize data by performing token replacement. To modify the contents of the lookup tables used in Advanced Transformer, Open Parser, and Table Lookup, use the Table Management tool in Enterprise Designer.