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
Using the Analysis Tools With Sun Master Index (Repository)
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
Extracting Legacy Data Using the Data Integrator Wizard
Connecting to the Source Database
To Connect to the Source Database
Creating the Staging Database and ETL Collaboration
To Create the Staging Database and ETL Collaboration
Connecting to the Staging Database
To Connect to the Staging Database
Extracting the Data Using Data Integrator
To Extract the Data Using Data Integrator
Extracting Legacy Data Using the Generate Schema Tool
Creating the Staging Database
To Create the Staging Database
Connecting to the Staging Database
To Connect to the Staging Database
Connecting to the Source Database
To Connect to the Source Database
Creating the ETL Collaboration and Extracting the Data
To Create the ETL Collaboration and Extract the 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
Adjust 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