Documentation Home
> Analyzing and Cleansing Data for Sun Master Index
Analyzing and Cleansing Data for Sun Master Index
Book Information
Analyzing and Cleansing Data for Sun Master Index
Related Topics
Data Cleansing and Analysis Overview
About the Data Profiler
About the Data Cleanser
Data Cleansing and Profiling Process Overview
Required Format for Flat Data Files
Generating the Data Profiler and Data Cleanser
To Generate the Data Profiler and Data Cleanser
Configuring the Environment
To Configure the Environment
Extracting the Legacy Data
Determining the Fields to Analyze
Defining the Data Analysis Rules
To Define Data Analysis Rules
Performing the Initial Data Analysis
To Perform the Initial Data Analysis
Reviewing the Data Profiler Reports
Configuring the Data Cleansing Rules
To Configure the Data Cleansing Rules
Cleansing the Legacy Data
To Cleanse the Data
Performing Frequency Analyses on Cleansed Data
Adjusting the Master Index Configuration
Data Profiler Rules Syntax
Data Profiler Processing Attributes
Data Profiler Global Variables
Simple Frequency Analysis Rules
Constrained Frequency Analysis Rules
Pattern Frequency Analysis Rules
Data Cleanser Rules Syntax
Data Cleanser Processing Attributes
Data Cleanser Global Variables
Data Validation Rules
dataLength
dateRange
matchFromFile
patternMatch
range
reject
return
validateDBField
Data Transformation Rules
assign
patternReplace
replace
truncate
Conditional Data Rules
dataLength
equals
isnull
matches
Conditional Operators
Data Profiler Report Samples
Simple Frequency Analysis Report Samples
Constrained Frequency Analysis Report Samples
Pattern Frequency Analysis Report Samples
© 2010, Oracle Corporation and/or its affiliates