Configuring the key generation for the first pass

Procedure

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here