Defining the composite View - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English (United States)
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
Available in...

Data Fabric

MDM Platform

Procedure

  1. In the Viewable Business Elements area, click the button to add a new XPath line to the table.
  2. In the new XPath line, click the three-dot button to open a dialog box.
    From the Data Models list, select the data model holding the entities on which you want to create the composite View.
    All entities constituting the model are listed in the dialog box.
    Note: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
  3. Select the entities/element to be retrieved by the View being defined.
  4. Consider as an example that your data model has the two entities: Agency and Agent. You want to create a composite View that joins elements in both entities to show multiple data records for the same agent if he/she is attached to multiple agencies.
    In the Searchable Business Elements area, click the button to add a new XPath line to the table.
    Note: When defining a search filter view, the first line in the Searchable Business Elements area must be the xPath to an attribute of the main entity.
  5. In the new XPath line, click the three-dot button to open a dialog box where you can select the entities or elements to be located.
    Note: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
  6. In the Where Conditions area, click the button to add a new XPath line to the table.
    In the new XPath line, click the three-dot button to open a dialog box where you can select the entities/elements on which you want to define a join condition.
    Note: You can filter the entities you want to display in the dialog box if you type in the Filter field the text according to which you want to filter business entities. This is a search-as-you-type filter where entities are instantly filtered as you type your search string.
    Warning: You must use the "Join With" operator when creating a composite View in order to specify the join in the WHERE clause. Usually, you join on elements keys. If there are more than one keys to join on, you must repeat a "Joins With" clause for each part of the key. For instance, suppose the AgencyFK is a compound key that comprises Id and Date, you must define two conditions in the "Where Condition" table: "Agent/AgencyFK --> Joins With --> Agency/Id" and "Agent/AgencyFK --> Joins With --> Agency/Date".
    The WHERE clause used in this example will generate multiple data records for the same agent linked with different agencies.
  7. Click the save icon on the toolbar or press Ctrl + S on your keyboard to save your changes.

Results

The newly created View is listed under the View node in the MDM Repository tree view.

Using Talend MDM Web UI, an authorized business user can now visualize the records in the two specified entities according to the defined join clause.

Note: You can attach a Process to the View in order to transform/enrich data, on the fly, by looking up fields in the source system.

For further information, see Running the view result through a Process (registry style lookup).