Extracting Reference Data for DNM, UNM Jobs

To extract the Reference Data for Data Normalization Module and Universal Name Module jobs you need to run the data loader script, for example installdb_dnm.

Ensure the script file (for example installerdb_dnm), and the JAR file reside in the same folder.
  1. Log in to your machine.
  2. Change the directory to the location where you have installed the SDK.

    After you have successfully installed the Spectrum™ Data & Address Quality for Big Data SDK on your machine, you should have the Reference Data loader in the directory BDQ_InstallPath/SDK/utilities/dbloader/unix/bin.

  3. Run the reference data loader script. (For example, installdb_dnm).
    A numbered list of stages is displayed and you are prompted to select the stage.
  4. Type the number corresponding to the stage for which you want to load the data.
  5. Specify the path where you want the reference data sets to be extracted and placed after download.
    The reference data input are the base tables of Data Normalization Module, core name data bases required to perform the Data Normalization and Universal Name Module jobs.
  6. Specify the path for the output directory.
  7. The system prompts whether you want to view the log file. Select as desired.
  8. The system starts loading the data. The data is extracted in the specified output directory.
  9. Repeat the steps for each stage.
Reference data is now available to be used.
Note: You must have write permission to the reference data path to run the jobs.