Attaching a Match Rule to a Data Model - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Data Fabric

MDM Platform

About this task

To attach a Match Rule to a Data Model, do the following.

Procedure

  1. In the MDM Repository tree view, open the Data Model to which you want to attach the Match Rule.
  2. Select the entity and, in the Properties view, open the Rules tab.
  3. In the Match Rule section, select the Match Rule you want to attach to this Data Model from the drop-down list.
    If needed, click Open Match Rule to open and view the details of the Match Rule.
  4. Map each Match Key to the corresponding Entity element using the selection window.
    If you want to attach a match rule with multiple rules to a data model, make sure each match key is mapped to an entity element correctly in each rule within the match rule.
    You can select any simple type elements at the root level from a single entity and the entities linked by a foreign key (if any) defined in the previous entity. Note that the survivorship function does not take effect on the elements selected from those foreign key entities.
    For an example of defining a match rule with match keys mapped to simple type elements from multiple entities, see An example of defining a match rule with match keys mapped to simple type elements from multiple entities.
    Warning: Once a data model is attached with a match rule mapped to multiple entities, the integrated matching performance might be affected if a large number of data records pertain to one of the entities since the query with JOIN operations on large tables will be time-consuming for database.
  5. If you have defined the survivorship rules for columns in the match rule, map each column to the corresponding entity element using the selection window.
    You can select any simple type elements at the root level from a single entity and the entities linked by a foreign key (if any) defined in the previous entity. Note that the survivorship function does not take effect on the elements selected from those foreign key entities.
  6. Click the [+] button and, from the Select Element dialog box that opens, select one element to be used as the blocking key.
    Alternatively, select the Use the built-in "Blocking Key" column check box to use the built-in blocking key which has been predefined in the Staging Area and according to which you want to partition the processed data in blocks. A built-in blocking key is defined using a Job (with a single column or the transformation of multiple columns). The Job can connect directly to the database to update this built-in blocking key.
    Note: Defining a blocking key is not mandatory but strongly advisable. Integrated Matching performs faster when the matching defines a blocking key, thanks to parallelization. For the best performance, the database column used as a blocking key should be indexed.
  7. Save your changes.