In the Repository tree view, expand
Metadata - DB
Connections where you have stored the main input schemas and
drop the relevant file onto the design workspace.
The Components dialog box
Select tMysqlInput and click OK to drop the tMysqlInput component onto the workspace.
The input table used in this scenario is called
person. It holds several columns including the two
columns name and email we want to
do the fuzzy match on. The following capture shows the basic properties of
the main input component:
Do the same for the second input table you want to use as a reference,
customer in this scenario.
The following capture shows the basic properties of the reference input component:
Drop the following components from the Palette onto the design workspace: tRecordMatching and three tLogRow.
Connect the main and reference input components to tRecordMatching using Main
links. The link between the reference input table and tRecordMatching displays as a Lookup link on the design workspace.
Connect tRecordMatching to the three
tLogRow components using the Matches, Possible
Matches and Non Matches