An example of defining a match rule with match keys mapped to simple type elements from multiple entities - 6.5

Talend Data Fabric Studio User Guide

EnrichVersion
6.5
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The following example introduces how to define a match rule with match keys mapped to simple type elements from both an entity Customer and an entity Address which is linked by a foreign key defined in the Customer entity in the Customer data model.

Prerequisites:

  • Make sure the data model Customer and its corresponding data container Customer already exist.

  • Make sure the Customer entity has foreign key relationships with the Address entity in the Customer data model.

  1. Create a match rule as described in Creating a Match Rule.

    In this example, a match rule MatchCustomer is created.

  2. Define the match rule according to your needs.

    In this example, add three match keys: CustomerName, City and Street.

  3. Attach the match rule to the Customer entity.

    In this example, the match key CustomerName is mapped to the name element of the Customer entity, City is mapped to the city element of the Address entity which has foreign key relationships with the Customer entity, and Street is mapped to the street element of the Address entity.

    Make sure to select only simple type elements at the root level after you click the [...] button in the XPath column to open the [Select Element] dialog box and map a match key to an element.