Creating One-source Match stage jobs

The One-source Match stage job requires that you add the One-source Match stage to the job and link it to two source stages and up to five output stages.

  1. From the palette, select the One-source Match stage and drag it onto the middle of the DataStage® design canvas.
  2. From the palette, add two input stages. Add one for each of the following data sources.
    • Data source
    • Frequency information for the data source

    Typically, your source data comes from a file or database but you can also use other stages to preprocess the data before it is input to the One-source Match stage.

  3. Link the input stages in the following order.
    • Data
    • Data Frequency
  4. From the palette, add up to five output stages, one for each of the output options that you intend to use in the One-source Match stage.
    The following list shows the five output options.
    • Match
    • Clerical
    • Duplicate
    • Nonmatched
    • Match Statistics
    For the output stages, you can use any file, database, or processing stage.
  5. For the match output options that you intend to use, link the stages in the following order.
    1. Match
    2. Clerical
    3. Duplicate
    4. Nonmatched
    5. Match Statistics
    Note: Verify in the Link Ordering section on the Input tab and the Output tab that the link labels and link names are correct.
  6. Double-click an input stage, then configure it.
    1. In the Properties section of the Output tab, in the text box for File, type the file name, including the path, which the input data will read.
      If you used a stage other than a file stage for the input, select the appropriate input and define any additional properties that the source requires.
    2. In the Columns section of the Output tab, click Edit, then choose Importing existing data definitions. When you select the data definition for the frequency input, use the data definition that was created when the Frequency Match job was run.
    3. In the Properties section of the Input tab, in the text box for File, enter the file name to write the output data to.
    4. Click Apply and Return, then Save.
    5. Repeat these steps until all the input stages are configured.
  7. Double-click an output stage, then configure it.
    1. In the Properties section of the Input tab, in the text box for File, enter the file name to write the output data to.
      If you used a stage other than a file stage for the output, select the appropriate output and define the properties that the target requires.
    2. Click Apply and Return, then Save..
    3. Repeat these steps until all the output stages are configured.
  8. Optional: Rename the stages and links with meaningful names that reflect their functions in the job or project.