Using Reference Data: Data Normalization Module and Universal Name Module

To use the Reference Data for Data Normalization Module and Universal Name Module you need to run the data loader script file, for example installdb_dnm. Executing the script file enables you to extract Reference Data to your machine.

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 Big Data Quality 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 the reference data sets are extracted and placed after download.
    The reference data input are the base tables of Data Normalization Module, core name data bases, and the like, which are required to perform the Data Normalization and Universal Name Modules' jobs.
  6. Specify the path for the output directory. This is the path where your input data will be extracted to.
  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.
Note: Repeat the steps for each stage.