Skip Navigation Links | |
Exit Print View | |
Loading the Initial Data Set for a Master Index Java CAPS Documentation |
Loading the Initial Data Set for a Master Index
Initial Bulk Match and Load Overview
Initial Bulk Match and Load Process Overview
Data Preparation, Matching, and Loading Procedure Overview
About the Cluster Synchronizer
Required Format for Flat Data Files
Generating the Initial Bulk Match and Load Tool
To Generate the Initial Bulk Match and Load Tool
Creating the Cluster Synchronizer Database
To Create the Cluster Synchronization Tables
Configuring the Initial Bulk Match and Load Tool
Configuring the Initial Bulk Match and Load Tool Processing
Configuring Initial Bulk Match and Load Tool Logging
To Configure IBML Tool Logging
Initial Bulk Match and Load Tool Configuration Properties
Initial Bulk Match and Load Tool Field Validation Configuration
Initial Bulk Match and Load Tool Blocking Query Configuration
Initial Bulk Match and Load Tool Match String Configuration
Initial Bulk Match and Load Tool Processing Configuration
Cluster Synchronizer Database Configuration
Initial Bulk Match and Load Tool Logging Properties
Running the Bulk Matcher in Analysis Mode
To Run the Bulk Matcher in Analysis Mode
Reviewing the Match Analysis Results
Reconfiguring the Matching Logic
To Reconfigure the Matching Logic
Loading the Matched Data Into the Master Index Database
Loading Matched Data Using SQL*Loader
To Load Matched Data Using SQL*Loader
Loading Matched Data Using the Command-Line Bulk Loader
After you perform the match analysis and are satisfied with the matching logic configuration, you can either run the match process alone, or you can run the match and load processes together if you are using SQL*Loader to load the data. SQL*Loader can only be used on an Oracle master index database. To run the match process separately, see Performing the Bulk Match.
A new directory named sqlldr is created in the working directory.
chmod u+x *.sh
Tip - If for any reason you need to stop and restart this process, run truncate.sql in the sqlldr directory against the master index database before restarting the process.