After you create a job that contains this stage, select
from available match specifications and other settings that determine
matching records in two data sources.
Procedure
- Open the DataStage® flow that
contains the Two-source Match stage that you want to configure.
- Double-click the Two-source Match stage.
- In the Match Specification field, click
Browse and select a two-source match specification.
- Optional: To override any of the match cutoff
values from the match specification that you selected, select Override
cutoffs and enter new values or job parameters in the Match, Clerical,
or Duplicate columns.
- Optional:
To enter specific values for the override match cutoffs, click the pencil icon next to a value
and enter the new value. Click the ⋮ icon to take one of the following
options.
Option |
Action |
Use an existing job parameter. |
Select Insert Parameter and choose an existing parameter. |
Return to match cutoff values from the match specification. |
Select Use match specification. |
- From the drop-down list for the Match Type, choose a match type.
- In the Match Outputs pane, select one or more outputs that
you want to create. Be aware of the following conditions.
- Each output that you select must have a corresponding output link.
- No output can be sent to more than one link.
- Click Stage Properties.
- In the column section of the Output tab, for any one output,
select Edit to modify output columns.
- Click Save.