Configuring the key generation for the first pass
-
Double-click the first tGenKey to open
the Component view.
-
Click
and import blocking keys from match rules created and
tested in the
Profiling
perspective
of
Talend Studio
and use them in your Job. Otherwise,
define the blocking key parameters as described in the below steps. -
Under the Algorithm table, click the
[+] button to add two rows in the
table. -
In the column column, click the newly added row and
select from the list the column you want to process using an algorithm. In this
example, select lname. -
Do the same on the second row to select
postal_code. -
In the pre-algorithm column, click the newly
added row and select from the list the pre-algorithm you want to apply to the
corresponding column.In this example, select remove diacritical marks and
convert to upper case to remove any diacritical mark and converts
the fields of the lname column to upper
case.This conversion does not change your raw data. -
In the algorithm column, click the newly
added row and select from the list the algorithm you want to apply to the
corresponding column. In this example, select N first
characters of each word.If you select the Show help check box, you
can display instructions on how to set algorithms/options parameters. -
Do the same for the second row on the algorithm column to select first N
characters of the string. -
Click in the Value column next to the
algorithm column and enter the value for
the selected algorithm, when needed.In this scenario, enter 1 for both rows. The first letter
of each field in the corresponding columns will be used to generate the
key.Make sure to set a value for the algorithm which need one, otherwise you may
have a compilation error when you run the Job.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments