Extracting 3rd Normal Form (3NF) Data - trillium_discovery - trillium_quality - Latest
Trillium Control Center
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478
About this publication
Welcome to Trillium DQ
Using the Online Help System
Search Methods and Syntax
Configuring Locale for Language Packs
Locale View
Getting Started
About Trillium Terminology
Trillium Architecture
About Repository Servers and Repositories
About Loader Connections and Data Sources
About the Repository Manager
About the Repository Manager
User Categories
User Security
Using Windows Authentication Security
Using Trillium Authentication Security
Logging in to the Control Center
Switching Users or Repositories
Switching Repository Servers
Saving Repository Connections
Setting Preferences
Changing Your Password
Setting Up Email Notifications
Customizing Email Notifications Using Variables
Setting Environment Options
Changing the Display Style
Setting List View Options
Setting Entity Relationship Diagram Options
Detail Value Options
Setting Notification Options
Setting Icon Options
About Entities
Real Entities vs. Dynamic Entities
About Dynamic Entities
Sample Data Files
Creating an Entity
Creating Schema Files for Fixed-Length Files
Creating an Entity from the Client
Monitoring the Entity Creation Process
Verifying New Entities
Data Representation
Managing Entities
Editing an Entity
Renaming an Attribute
Sort Entities and Attributes In Navigation View
Deleting an Entity
About Projects
Modifying Project Properties
Deleting Projects
Tour of the Control Center
About the Control Center
Getting Started Page
About Navigation View
Opening and Closing Navigation View
Navigation Bars and Tabs
List of Repository Objects
Using the Navigation View
Resizing the Navigation View
About List Views
Opening Multiple List Views
Saving Data in List Views
About Navigating in List Views
Drilling Down to Details
Stopping a Drilldown
Cycling Between List Views
Moving to a Specific Row
Ways to Organize List View Information
Creating a Column in a List View
Re-Positioning Columns in List Views
Hiding Columns in a List View
Displaying Hidden Columns
Pivoting Data in a List View
Hiding Data Rows in List Views
Zooming to Display Only Selected Data in a List View
Filtering Information in a List View
Displaying Wide Values in a List View
Sorting Columns of Data
Sorting Columns by Length
Sorting Columns by Value
Sorting on Multiple Columns
Ways to Resize Columns
Resizing a Column by Dragging the Label Border
Resizing Column Widths to Fit Data
Resizing Column Width to Fit Heading Labels
About Process Flow Views
Opening a Process Flow View
About Icon Views
Opening Icon View
About Metadata Summary Views
Structure of Metadata Summary Views
How to Use Metadata Summary Views
List of Summary Items
Notifications
Scheduler Notifications
Task Progress Notifications
Message, Error, and Warning Notifications
About Message View
Viewing Messages
About Background Tasks
Viewing Background Tasks
Deleting Background Tasks
Discover
Exploring Data Analysis
Discovering Data Structure
Data Structure Elements
What is an Entity?
Viewing Entity Metadata
Entity Tasks Menu
Determining the Entity Source
Ways to Profile Large Entities
Attributes
Viewing Attribute Metadata
Examining Attributes
Modifying Attribute Properties
Using Derived Metadata Rules
Creating an Index for an Attribute
Renaming an Attribute
What is a Row?
Drilling Down on Rows
Examining Duplicate Data Rows
Examining NULL Values in Rows
Understanding Data Structure
Viewing Entity Rows and Attributes
Identifying the Number of Rows in an Entity
Identifying the Number of Attributes in an Entity
Examining the Length of Attributes
Examining Frequency Counts of Attributes
Examining Integer and Decimal Datatype Percentage Distribution
How to View Datatypes
Data Content
Data Values
How to Find Value Counts
How to Find Value Ranges
Examining Distinct Values
Values List View
Examining Minimum and Maximum Attribute Values
Comparing Attribute Values
How Value Lengths are Calculated
Recoding Data Values
Generating Recode Value Look-Up Tables
About Masks
Viewing Masks
Recoding Masks
Viewing Recoded Masks
Generating Recode Mask Look-Up Tables
About Patterns
Examining Patterns
More on Default, Rich and Long Patterns
About Soundexes
Examining a Soundex
Finding Attributes with Soundexes
About Metaphones
Examining Metaphones
About Percentiles
Examining Percentiles
About Standard Deviation
Examining Standard Deviation
Understanding the Standard Deviation Graph
About Phrase Analysis
Analyzing Word Phrases in an Attribute
Viewing Phrase Analysis Results
Disabling Phrase Analysis for Attributes
Ignore Words
Adding and Importing Ignore Word Tables
Adding and Managing Ignore Words
About Word Definition Table
Creating Word Definition Tables
Adding Word Definitions from Wide Values
Adding and Managing Word Definition Categories
Creating and Managing Synonyms
Managing Word Definition Tables
Analyzing Data Relationships
About Join Analysis
Join Analysis
Finding (Discovering) Potential Joins
Validating (Creating) Joins
Setting Join Status
Displaying Join Metadata
Including an Attribute in a Join
Removing an Attribute from a Join
Join Metadata
Viewing Permanent Joins
Viewing Metadata for a Permanent Join
Viewing Metadata for Discovered Joins
Displaying Multiple Attributes in Joins
Creating an Entity From Joined Data
Deleting Joins and Join Jobs
About Venn Diagrams
Viewing Venn Diagrams
Drilling Down From Venn Diagrams
Printing a Venn Diagram
About Entity Relationship Diagrams
Viewing Entity Relationship Diagrams
Formatting Entity Relationship Diagrams
Saving Entity Relationship Diagrams
Opening a Saved Entity Relationship Diagram Layout
Exporting Entity Relationship Diagrams
About Key Analysis
How to Analyze Keys
Reviewing Key Analysis Results
Creating a Key
Verifying a Key
Re-Running a Key Analysis
Disabling Key Analysis
About Dependency Analysis
Reasons to Analyze for Dependencies
About Dependency Rules
How to Analyze Dependencies
Validating Potential Dependencies
Exploring Conflicting Values
Reviewing Dependency Analysis Results
Creating a Dependency
Verifying a Dependency
Re-Running a Dependency Analysis
Resolving Dependency Conflicts
Disabling Dependency Checks
Extracting 3rd Normal Form (3NF) Data
Data Compliance Using Business Rules
About Business Rules
Things to Consider When Creating Business Rules
About Entity Business Rules
Creating Entity Business Rules
Configuring Advanced Options When Creating Entity Business Rules
Applying Entity Business Rules
Navigating to Entities from List View
Copying Entity Business Rules Between Entities
About Attribute Business Rules
About Out-of-the-Box Attribute Business Rules
Creating Attribute Business Rules
Creating Attribute Business Rule Using Selected Metadata
Business Rule Analysis
Monitoring Business Rule Analysis Business Rules
Business Rule Results
Viewing Business Rule Analysis Results
Viewing Business Rules Analysis Details
Viewing Business Rules in List View
Business Rule Compliance Checks
Compliance for Entities
Compliance for Attributes
Manage Business Rules
Editing a Business Rule
Editing Derived Rules
Categorizing Business Rules
Adding Categories and Subcategories
Managing Categories and Subcategories
Associating Categories to Business Rules
Prioritizing Business Rules
Adding Priorities
Managing Priorities
Modifying Business Rule Priority Associations
Searching Business Rules
Enabling and Disabling Rules
Deleting a Business Rule
Exporting Business Rules
Discovery Center
About the Expression Builder
Expression Elements
Expression Builder Attributes
Expression Builder Functions
Expression Builder Operators
Expression Builder Literal Expression
Using Escape Characters
Using the Expression Builder Window
Filtering List Views Using Expression Builder
Business Rules Library
About Library ABRs
Creating Library ABRs
Creating and Editing Library Attributes
Promoting ABRs to Library Attributes
Associating Library Attributes
Disassociating Library Attributes
Exporting and Importing Library Attributes
Deleting Library Attributes
About Library EBRs
Promoting EBRs to Library Entities
Associating Library Entities
Disassociating Library Entities
Editing Attribute Mappings
Editing Library Entities
Exporting and Importing Library Entities
Deleting Library Entities
Manage Business Rules Library
Copying Library Rules
Editing Library Rules
Deleting Library Rules
About Rule Groups
Adding Library Rules to Rule Groups Folders
Working with Rule Groups Folders
Analyzing Business Rules in Rule Groups Folders and Sub-Folders
Viewing Rule Analysis Results in Rule Groups
About Saved Searches
Adding a Saved Search
Working with Saved Searches
Copying Compliance Standards
Copying Entity Metadata to a New Entity
Adding Data to an Empty Entity
Using Data Analysis Projects
About Baseline Analysis
Planning Baseline Analysis Projects
Creating Baseline Analysis Projects
Managing Baseline Analysis Projects
Opening a Baseline Analysis Project
Baseline Analysis Project Metadata
Viewing all Attributes in a Baseline Analysis Project
Editing a Baseline Analysis Project
Auditing Baseline Analysis Projects
Deleting a Baseline Analysis Project
Copying Entity Metadata to a New Baseline Analysis Project
About Time Series Analysis
Creating a Time Series Analysis Project
Generating the Next Entity
Managing Time Series Projects
Opening a Time Series Project
Time Series Project Metadata
Editing a Time Series Project
About Configuring an Automation Interval
Deleting Time Series Entities
Deleting Time Series Projects
Viewing Time Series Results
Monitoring Attribute Compliance with Time Series
Monitoring Entity Compliance with Time Series
Reviewing a Summary of Metadata Changes
About Join Projects
About N-Way Joins
Creating a Join Project
Join Project Metadata Summary
Working with a Join Project
Adding a Join to a Join Project
Copying a Join Project
Editing Join Output
Exporting and Importing Join Projects
Using Data Findings to Collaborate
About Notes
Creating Notes
Note Classes and Subclasses
Finding Existing Notes
Viewing Notes
Editing, Printing, and Exporting Notes
Deleting Notes
About Bookmarks
About Managing Bookmark Access
Creating Bookmarks
Viewing Bookmarks
Deleting Bookmarks
Viewing Event Logs
Ways to Export Findings
Exporting Findings
Customizing Exported HTML Files
Exporting Entity Schema from the Navigation View
Copying List Views to Other Applications
Develop
TS Quality Projects
Identifying Quality Data Objectives
Name and Address Project
Business Data Projects
Creating a Name and Address Project
Specifying Project Information
Selecting Input Entities
Selecting Country Flows
Selecting the Final Process
Configuring the Global Data Router
Specifying the Customer Data Parser Inputs
Running the Project Creation Job
Creating a Real-Time Project
Creating a Business Data Project
Creating an Empty Quality Project
Routing Country to Another Country
Deleting a Project
Modifying Quality Projects
Opening a Project
Running a Project Job
Regenerating Input Data
Copying an Entity from Profiling
Replacing an Entity for an Existing Project
Working with the Project Library
Copying to the Project Library
Viewing and Editing Library Project Details
Using Library Projects
Copying a Library Project into a Workflow
Adding New Input
Mapping Attributes
Inserting Library Processes into a Workflow
Exporting and Importing Library Projects
TS Quality Processes
List of Quality Processes
Editing Process Name and Description
Adding and Deleting a Process
Editing Process Configuration
Specifying Input and Output
Changing Entities for a Process
Adding New Process Inputs
Executing a Process
Copying a Process
Debug Settings
Using Masks
User Defined Masks
Removing Rows
Using the Schema Editor
Opening the Schema Editor
Adding and Deleting Attributes
Copying and Moving Attributes
Modifying Attributes
Filtering Attributes
Mapping Multiple Inputs to the Output Schema
Redefining Attributes
Redefining Attributes by Drag-and-Drop
Redefining Attributes by Editing
Redefining Attributes by Merging
Regenerating Output Schema
Using Inherited Attributes
Using Schema Editor with External Files
Editing Input Schema
About the Expression Builder
Using the Expression Builder Window
Things to Consider When Creating Business Rules
Expression Elements
Expression Builder Attributes
Expression Builder Functions
Functions for Sets of Records
Functions DEDUPE
Using Quality Functions for Asian Countries
Quality Functions
Full-width (Zenkaku) and Half-width (Hankaku) Japanese Characters
Japanese Romaji Table
Japanese Sound Marks (Dakuten and Handakuten)
Expression Builder OperatorsExpression Builder
Expression Builder Literal Expression
Using Escape Characters
Filtering List Views Using Expression Builder
Filtering Input and Output Rows Using Expression Builder
Setting Conditions Using Expression Builder
Setting Attributes Using Expression Builder
About Library Business Rules in Quality Projects
Using Library Business Rules in a Quality Project
Viewing Output Rows
Using Process Specific Previews
Analyzing Output Entities
Viewing Process Report Files
Using a Graphical Statistics File
Profiling Processes
Using the Analysis Process
Adding an Analysis Process
Using the Load Process
Adding a Load Process
Using the Business Rules Process
Adding a Business Rules Process
Using the Dependencies Process
Adding a Dependencies Process
Using the Keys Process
Adding a Keys Process
Decision Point Process
Adding a Decision Point Process
Inserting a Decision Point Process
About Entity Group
Creating an Entity Group
Create Entity Grouping for Country Flow
Working with Entity Groups
Data Browser
Browsing a Data File with a DDL
Browsing a Data File without a DDL
Browsing a Delimited Data File
Searching Data Within a File
Specifying Record Criteria
Exporting Data
Database Read/Write Feature
Reading Data from a Database for a Batch Script
Writing Back Data to a Database
Transformer
Editing Output Schema
Specifying Parser Inputs
Delimited File Option
Scanning Attributes
Transforming Attributes
Translating Characters
Recoding Data Using Tables
Attribute-based Recode Tables
Entity-based Recode Tables
File-based Recode Tables
Using a Phrase Separator for File-based Recode Tables
Recoding Data Using Multiple Attributes
Regenerating Recode Tables
Using Japanese Itai Table
Validating Data Using Table Range
Using Table Range
Editing Transformation Rules
Copying Transformation Rules
Creating Conditional Transformation Rules
Moving and Deleting Transformation Rules
Duplicating Scan Rules
Reusing Transformation Rules
Generating Source ID and Sequence Number
Generating System Date/Time
Editing Advanced Rules Files for Transformer
Special Transformers
Transformer Address Reconstruction
Transformer Data Reconstruction
About Derived Name and Address Attributes
Transformer Global Postal
Transformer Label Lines
Changing the Label Lines Rules for the United Kingdom
Transformer Pre Postal Matcher
Transformer Unified Output
XML Format
Conditionals Settings
Structure of Conditional Statements
Using Conditional Statements
List of Conditional Statement Arguments
Description of Conditional Statement Arguments
Conditionals Settings Examples
Attribute Scan Settings
Scan and Change Example
Scan and Flag Example
List of Attribute Scan Arguments
Description of Attribute Scan Arguments
Table Recode Settings
Table Recode - Literal
Table Recode - Mask
List of Table Recode Arguments
Description of Table Recode Arguments
Third-Party Web Services
Configuring Third-Party Web Services
Global Data Router
Specifying Global Data Router Input and Output Settings
Adjusting Router Countries
Specifying Global Data Router Input Attributes
Specifying Global Data Router Advanced Settings
Editing Advanced Rules Files for Global Data Router
Parameters for Global Rules Table
Parameters for Country Rules Table
Specifying Advanced Settings for Asian Countries
Customer Data Parser
Customer Data Parser Process
Setting Up the Customer Data Parser
Customer Data Parser Schema Editor
Customer Data Parser Options
Defining Parser Input Line Types
Selecting Names to Write
Identifying Business Names
Modifying Review Group Order
Specifying Advanced Customer Data Parser Settings
Advanced Customer Data Parser Settings
Fill Attribute Settings
Joining Customer Data Parser Input Lines
Splitting Customer Data Parser Input Lines
Transforming Attributes in the Customer Data Parser Process
Specifying Name Rules
Specifying Street Rules
Editing Advanced Rules Files for Customer Data Parser Customer Data Parser (CDP)
Special Apartment Number Processing
Analyzing Results of the Customer Data Parser
About Customer Data Parser for Asian Countries
Parsing Names for China, Korea, and Taiwan
Specifying Output Settings for China, Korea, and Taiwan
Specifying Parser Options for China, Korea, and Taiwan
Viewing Customer Data Parser Results for China, Korea, and Taiwan
Parsing Names for Japan
Specifying Parser Inputs for Japan
Single Attribute Method for Japan
Standard Input Method for Japan
Specifying Output Settings for Japan
Specifying Parser Options for Japan
Converting Small Kana Characters for Japan
Deleting Comments for Japan
Separating Branch Name for Japan
Viewing Customer Data Parser Results for Japan
Analyzing PNP/BNP Confidence of the Customer Data Parser for Japan
Analyzing Mask Logic Status for Japan
Business Data Parser
Configuring the Business Data Parser
Importing an Ignore Word Table and Word Definition Table
Ignore Word Tables for the Business Data Parser
Specifying Input and Output
Business Data Parser Definitions
Adding Word and Phrase Definitions in BDP
Analyzing Phrases in a BDP Attribute
Viewing Phrase Analysis Results
Adding Mask Definitions
About Business Data Parser Patterns
Setting Business Data Parser Options
Transforming Business Data Parser Attributes
Customizing Output Attributes
Editing Advanced Rules Files
Specifying Business Data Parser Encoding Values
Running the Business Data Parser
Viewing Business Data Parser Results
About Business Data Parser Review Codes
Analyzing and Reviewing Business Data Parser Review Codes
Parser Completion Codes (CDP/BDP)
Parsing Rules Customization
Using the External Parser Tuner
About Parser Definition Tables
Parser Pattern Structure
Parser Tuner Definition Syntax
Tokens
Operations
Line Types
Positions
Attributes
Attribute Modifiers
Synonyms
Assigning a Line Type with a Pattern for CDP
Constructing Name Patterns
Conventions in Parsing Customization
Special Entries
Function Attribute Modifiers
Customizing the Parsing Rules
Adding a Definition to a Custom Definition Table
Applying New Parsing Rules
Correcting Pattern Problems
Correcting Word Problems
Opening the Parsing Exceptions File
Reviewing Errors in Parsing Customization
Reviewing Parser Statistics
Using the Table Attribute Filter
Customizing the Parsing Rules for China, Japan, Korea, and Taiwan
About Parser Definition Tables for China, Japan, Korea, and Taiwan
Parser Definition Syntax
Name Entries
Geographic Entries
Pattern Entries
Keywords
Attribute Values for China, Japan, Korea, and Taiwan
Operations
Positions
Special Operations for Korea
Adding a Definition to a Customized Definition Table (CN, KR, and TW)
Customizing Token Masks in the Parsing Exceptions Analyzer (CN, KR, and TW)
Token Masks for China, Japan, Korea, and Taiwan
Adding a Definition to a Custom Definition Table for the JP Customer Data Parser
Syntax for the JP Parser Definitions Tables
Values for the JP Parser Definition Tables
Clue
BNP Name
PNP Name
Customizing the Token Masks
Mask Processing
Attributes for Mask Patterns
Rules for Token Masks
BNP Masks
PNP Mask Values
PNP Contact
Customizing the Parser Token Masks in the Parsing Exceptions Analyzer (JP)
Adding a Definition to a Custom Definition Table for the JP Postal Matcher
Customizing the Postal Matcher Token Masks in the Parsing Exceptions Analyzer (JP)
Name and Address Analyzer
Analyzing Name and Address Data
Postal Matchers
Editing Advanced Rules Files for Postal Matchers
Analyzing the Postal Matcher Results
Match Level Codes
Postal Matcher for Australia (AU)
Specifying AU Postal Matcher Options
Specifying AU Postal Matcher Advanced Options
Postal Matcher for Canada (CA)
How to Specify CA Postal Matcher Options
Specifying Canadian Postal Matcher SERP Settings
Postal Matcher for China (CN)
CN Postal Matching Process
Geographic Levels
Address Completion
Address Correction
Specifying CN Postal Matcher Options
Specifying CN Postal Matcher Advanced Options
About Custom Postal Matcher
Postal Matcher for Belgium (BE)
Postal Matcher for France (FR)
Postal Matcher for Luxembourg (LU)
Postal Matcher for Malaysia (MY)
Postal Matcher for Netherlands (NL)
Postal Matcher for Portugal (PT)
Postal Matcher for Singapore (SG)
Postal Matcher for Spain (ES)
Postal Matcher for Switzerland (CH)
Custom Postal Matcher Match Levels
Specifying Custom Postal Matcher Options
Custom Postal Matcher Options
Custom Postal Matcher - Country-Specific Requirements
Custom Postal Matcher - Directory Version
Editing Advanced Rules Files for Custom Postal Matcher
Custom Postal Matcher Rules File
Custom Postal Matcher Sample Rules File
Postal Matcher for Germany (DE)
Specifying DE Postal Matcher Options
Postal Matcher for the United Kingdom (GB)
Specifying GB Postal Matcher Options
United Kingdom (GB) Details Buffer Layout
About Global Postal Matcher
Postal Matcher for Austria (AT)
Postal Matcher for Brazil (BR)
Postal Matcher for Czech Republic (CZ)
Postal Matcher for Denmark (DK)
Postal Matcher for Finland (FI)
Postal Matcher for Greece (GR)
Postal Matcher for Hungary (HU)
Postal Matcher for Ireland (IE)
Postal Matcher for Mexico (MX)
Postal Matcher for Norway (NO)
Postal Matcher for New Zealand (NZ)
Postal Matcher for Poland (PL)
Postal Matcher for Sweden (SE)
Specifying Global Postal Matcher Options
Address Correction Result (ACR) Codes
Postal Matcher for Hong Kong (HK)
Specifying HK Postal Matcher Options
Postal Matcher for Italy (IT)
Populating the Output Record
Specifying IT Postal Matcher Options
Postal Matcher for Japan (JP)
Specifying JP Postal Matcher Options
Standard Postal Matcher for Japan (JP)
JP Postal Matching Process
Address Completion
Address Correction
Geographic Levels
Specifying JP Postal Matcher Advanced Options
JP Postal Matcher Address Code Edition (ACE)
Address Code
Bar Code
Jukyo Code
Specifying ACE Postal Matcher Advanced Options
ACE Postal Matcher Fail Levels
Analyzing the ACE Postal Matcher Results
Postal Matcher for Korea (KR)
KR Postal Matching Process
New Postal Code System for Korea
Geographic Levels
Address Completion
Address Correction
Specifying KR Postal Matcher Options
Specifying KR Postal Matcher Advanced Options
Postal Matcher for Taiwan (TW)
TW Postal Matching Process
New Postal Code System for Taiwan
Geographic Levels
Address Completion
Address Correction
Specifying TW Postal Matcher Options
Specifying TW Postal Matcher Advanced Options
Postal Matcher for the US (United States)
Specifying US Postal Matcher Options
Specifying US Census Options
Specifying DPV Options
Specifying LACSLink Options
Using CASS Certification Mode
Specifying SuiteLink Option
Specifying Abbreviation Option
Specifying Postal Form Settings
Specifying RDI Options
US Dual Address Information
US Dual Address Information Handling
Obtaining Street Names and Premise Details
United States (US) Details Buffer Layout
Postal Matchers for Asian Countries
Specifying Output Settings for China, Japan, Korea, and Taiwan
Specifying Mailing Address Line Rules
Specifying Control Changes
How to Modify Review Groups for Postal Matchers (China, Japan, Korea, Taiwan)
Analyzing the Postal Matcher Results for Asian Countries
Postal Matcher Fail Levels
Tuning the Postal Matching Rules
About the Geocoder
Adding a Geocoder Process
Specifying Geocoder Options
Assigning Coordinate Levels to Non US Countries
US Census Geocoding
About the Directory Browser
Using the Directory Browser
AU (Australia) Base Data Fields
CA (Canada) Base Data Fields
CN (China) Base Data Fields
Custom Country Base Data Fields
DE (Germany) Base Data Fields
GB (United Kingdom) Base Data Fields
Global Country Base Data Fields
HK (Hong Kong) Base Data Fields
IT (Italy) Base Data Fields
JP (Japan) Base Data Fields
KR (Korea) Base Data Fields
TW (Taiwan) Base Data Fields
US (United States) Base Data Fields
Data Linkers
Input and Output for Linking
Output Requirements for Linking
Processing a Large Number of Records
Debug Settings for Linking
Specifying Match Rules
Determining Matches
Converting Relationship Linkers to Reference Matchers
Using a Link File
Specifying Linking Settings
Multi-Matching
Window Key Generator
Creating the Window Key Rules
Selection (Primary/Secondary Field Code)
Editing Advanced Rules Files for Window Key Generator
How to Handle Large Window Keys
Specifying Window Sizing
Using a Cross-Reference File
Relationship Linker
Specifying Relationship Linker Process Settings
Editing Advanced Rules Files for Relationship Linker
Viewing Relationship Linker Results
Relationship Linker Results Analyzer
Examining Relationship Linker Results
Selecting Fields to View
Selecting Records to View
Resizing Column Width
Reference Matcher
Sample Reference Matching
Setting Up a Reference Matcher Process
Preparing a Reference Entity
Creating Reference Match Keys
Preparing an Input Entity
Creating a Reference Matcher Process
Configuring Reference Matcher Settings
Specifying Reference Matcher Process Settings
Specifying Reference Matcher Settings
Specifying Reference Options
Specifying Reference Output
Specifying Key Generation
Specifying Pattern Number Output
Specifying Attributes to Copy
Modifying Output Schema
Editing Advanced Rules Files for Reference Matcher
Viewing Reference Matcher Results
Linking Rules Customization
Data Comparison Calculator
Performing a Comparison Test
Comparison Routines
Relationship Linker Rules Editor
Using the Grade Pattern Editor
Reviewing Grade Patterns
Modifying Grade Patterns
Using the Field List Editor
Reviewing Field Lists
Modifying Field Lists
Creating a Field List and Grade Pattern
Checking for Errors
Using the Propagation Routines
Using Probabilistic Matching
Survivorship and Commonization
How to Specify Input and Output
Specifying Match Key Level
Designating the Survivor Row
Specifying Common Attributes
Decision Routines
User-Defined Process
Inserting a UDP as a Branch
Inserting a UDP as a Process
Setting Up a UDP
TS Quality Utilities
About the File Update Utility
Setting Up the File Update Utility
Input Settings
Output Settings
Input and Output Conditionals for File Update
About the Merge/Split Utility
Merging Files
Splitting Files
Input Settings
Split Options
Output Settings
About the Resolve Utility
Setting Up the Resolve Utility
Input Settings
Options
Output Settings
About the Set Selection Utility
Setting Up the Set Selection Utility
Input Settings
Input and Output Conditionals for Set Selection
Functions for Sets of Records
Output Settings
Set Selection Match Keys
About Sort Utility
Setting Up the Sort Utility
Input Settings
Specifying Sort Attribute and Order
Sort Collating Sequence
Specifying Sort Options
Output Settings
Deploying a Project
About Exporting/Importing Projects
Exporting a Project to a Batch Script
Exporting a Project Definition
Running a Batch Project
Updating the Configuration File
Deploying a Real-Time Project
Importing a Project
Manage
Reference Materials
Encodings, Data Types, and Date Formats
Encoding (Code Page)
Working with UTF-8 Data
Data Types
Date Format
Expression Builder Functions
Customer Data Parser Attributes
Customer Data Parser Attributes for Asian Countries
Customer Data Parser Attributes for China (CN), Korea (KR), and Taiwan (TW)
Customer Data Parser Attributes for Japan (JP)
Customer Data Parser Results
Parser Completion Codes (CDP/BDP)
Customer Data Parser Review Codes/Review Groups
Review Group Hierarchy
Customer Data Parser Change Flag
Customer Data Parser Results For Asian Countries
Return Codes for China, Korea, and Taiwan
Return Codes for Japan
Customer Data Parser Review Codes for China, Korea, and Taiwan
Customer Data Parser Review Groups for China, Korea, and Taiwan
Business Data Parser Attributes and Results
Business Data Parser Attributes
Parser Completion Codes (CDP/BDP)
About Business Data Parser Review Codes
Customer and Business Data Parser Definitions
Name Line Attributes
Street Line Attributes
Geography Line Attributes
Miscellaneous Line Attributes
Numerical List of Attributes
Function Attribute Modifiers
Intrinsic Attributes
Special Dictionary Files
BES Functions
CPLX01 Function
Beginning & Ending Positions: Logical vs. Physical
Special Routines
Street Pattern Routines
Name Pattern Routines
Postal Matcher Attributes
Australia (AU) Postal Matcher Attributes
Canada (CA) Postal Matcher Attributes
Custom Postal Matcher Attributes
Germany (DE) Postal Matcher Attributes
Geocoder Attributes
Global Postal Matcher Attributes
Hong Kong (HK) Postal Matcher Attributes
Italy (IT) Postal Matcher Attributes
TS Attributes
United Kingdom (GB) Postal Matcher Attributes
United States (US) Abbreviation Table Attributes
United States (US) Census Attributes
United States (US) DPV Attributes
United States (US) LACSLink Attributes
United States (US) Postal Matcher Attributes
United States (US) RDI Attributes
United States (US) SuiteLink Attributes
Postal Matcher Attributes and Results for Asian Countries
Postal Matcher Attributes for Asian Countries (China, Japan, Korea, and Taiwan)
Postal Matcher Attributes for JP Address Code Edition (ACE)
Review Codes for Postal Matchers (China, Japan, Korea, Taiwan)
Review Groups for Postal Matchers (China, Japan, Korea, Taiwan)
Relationship Linker Attributes
Standard Rules for Name and Address Linking
Standard Linking Rules for Countries Supported by the Independent Postal Matcher
Standard Linking Rules for Countries Supported by the Custom Postal Matcher
Standard Linking Rules for Countries Supported by the Global Postal Matcher
Standard Linking Rules for Countries Supported by the Asian Postal Matchers
Standard Linking Rules for Brunei Darussalam (BN)
Standard Linking Rules for Brazil (BR)
Standard Linking Rules for the United Kingdom (GB)
Standard Linking Rules for Countries without Postal Matchers
Relationship Linker Comparison Routines
ABSOLUTE Routine
ABSOLUTE With Modifier (UC)
APTNO Routine
APTNO With Modifier (01)
ARRAY1 Routine
ARRAY2 With Modifier (ARRAY2,n)
BUSNAME Routine
BUSNAME With Modifier (ACRONYM)
BUSNAME With Modifier (ALPHANUM)
BUSNAME With Modifier (COMPACT)
BUSNAME With Modifier (DECOMP)
BUSNAME With Modifier (DI)
BUSNAME With Modifier (NOCASE)
BUSNAME With Modifier (SORT)
CHARACTER Routine
DATE Routine
DATE With Modifier (JP)
DATE with Modifier (UC)
Character Decomposition Mapping
DIFFER Routine
DISTANCE Routine
FLAG10 Routine
FLAGFM Routine
FLAGGN Routine
FLAGMF Routine
FLAGYN Routine
FRSTNAME Routine
FRSTNAME With Modifier (DI)
FRSTNAME With Modifier (INITIAL)
FRSTNAME With Modifier (SYMETRIC)
FRSTNAME With Modifier (TSB)
GENER Routine
GENER With Modifier (95)
HOUSENO Routine
HOUSENO With Modifier (NORANGE)
HOUSENO With Modifier (PARITY)
LEVENSHTEIN Routine
LEVENSHTEIN With Modifier (ANCHOR)
LEVENSHTEIN With Modifier (DAMERAU)
LEVENSHTEIN With Modifier (EXACT)
LEVENSHTEIN With Modifier (RECIPROCAL)
LEVENSHTEIN With Modifier (TOLERANCE)
MXDNAME Routine
NYSIIS Routine
ONECOM Routine
PARTIAL1 Routine
PARTIAL1 With Modifier (10)
PARTIAL1 With Modifier (ARRAY1,n)
PARTIAL1 With Modifier (ARRAY2,n)
PARTIAL1 With Modifier (FM)
PARTIAL1 With Modifier (GN)
PARTIAL1 With Modifier (MF)
PARTIAL1 With Modifier (MU)
PARTIAL1 With Modifier (YN)
PARTIAL2 Routine
PARTIAL2 With Modifier (DATE)
PARTIAL2 With Modifier (NYSIIS)
PARTIAL2 With Modifier (RNYSIIS)
PARTIAL2 With Modifier (RSOUNDEX1)
PARTIAL2 With Modifier (RSOUNDEX1;S7)
PARTIAL2 With Modifier (RSOUNDEX2)
PARTIAL2 With Modifier (RSOUNDEX2;S7)
PARTIAL2 With Modifier (SOUNDEX1)
PARTIAL2 With Modifier (SOUNDEX1;S7)
PARTIAL2 With Modifier (SOUNDEX2)
PARTIAL2 with Modifier (SOUNDEX2;S7)
PARTIAL2 With Modifier (STATUS)
POSTCODE Routine
POSTCODE With Modifier (TSB, used in UK only)
POSTCODE With Modifier (UC)
PREFIX Routine
PREVENT Routine
RNYSIIS Routine
RSOUNDEX1 Routine
RSOUNDEX1 Routine With Modifier (S7)
RSOUNDEX2 Routine
RSOUNDEX2 Routine With Modifier (S7)
SOCSEC Routine
SOUNDEX1 Routine
SOUNDEX1 Routine With Modifier (S7)
SOUNDEX2 Routine
SOUNDEX2 Routine with Modifier (S7)
SOUNDEX1 Routines Comparison
SPELLING Routine
SPELLING With Modifier (ALPHANUM)
SPELLING With Modifier (DECOMP)
SPELLING With Modifier (DI)
SPELLING With Modifier (JP)
SPELLING With Modifier (KR)
SPELLING With Modifier (NOCASE)
SPELLING With Modifier (SQUISH)
SPELLING With Modifier (UC)
STATUS Routine
STREETS Routine
STREETS With Modifier (ALPHANUM)
STREETS With Modifier (DECOMP)
STREETS With Modifier (DI)
STREETS with Modifier (NI)
STREETS With Modifier (NOCASE)
STREETS With Modifier (TYPE)
SUBSTRNG Routine
SUBSTRNG With Modifier (AND)
SUBSTRNG With Modifier (UC)
TOKENIZE Routine
TOKENIZE With Modifier (ALPHANUM)
TOKENIZE With Modifier (DECOMP)
TOKENIZE With Modifier (DI)
TOKENIZE With Modifier (NOCASE)
TOKENIZE With Modifier (PHRASE2)
TOKENIZE With Modifier (SQUISH)
TWORET Routine
TWORET With Modifier (LO)
Use Cases
Data Profiling
Use Case: Create Entity Business Rule to Identify Data Anomaly
Data Quality
Use Case: Identifying Duplicates in Your Data - Relationship Linker
Step 1: Generate Window Keys to Group Rows
Step 2: Sort Rows by Window Key
Step 3: Configure and Run the Relationship Linker
Step 4: Examine Linking Results
Use Case: Profiling and Parsing Unstructured Business Data
Step 1: Perform Phrase Analysis
Step 2: Create a Word Definition Table
Step 3: Import a Word Definition Table
Step 4: Configure and Run the Business Data Parser
Notices