Configuring the query conditions and advanced settings to query staging data - Cloud - 8.0

MDM data processing
Version
Cloud
8.0
Language
日本語
Product
Talend Data Fabric
Talend MDM Platform
Module
Talend MDM Server
Talend MDM Web UI
Talend Studio
Content
ジョブデザインと開発 > サードパーティーシステム > MDMコンポーネント > MDMデータ処理コンポーネント
データガバナンス > サードパーティーシステム > MDMコンポーネント > MDMデータ処理コンポーネント
データクオリティとプレパレーション > サードパーティーシステム > MDMコンポーネント > MDMデータ処理コンポーネント
Last publication date
2023-09-14

Procedure

  1. In the Operations area, click the [+] button to add one new row, where you can define the query conditions.
  2. In the Xpath column, enter Customer/metadata:staging_status between quotes.
    In this example, we want to query the staging data that fails to pass the MDM validation phase due to a validation issue against the data model, and those staging data has the status of 403. For more information, see Working with records in the Staging Area.
    Note:

    Unlike elements defined in entities, metadata elements are built-in elements. To query metadata elements from records in staging database, you need to follow the format of metadata:staging_<source|status|error|blockkey|hastask> when defining the path expression to select the XML node to run the query on.

  3. Select Equal from the Function list.
  4. Enter 403 between quotes in the Value column.
  5. Click the Advanced settings tab.
  6. In the Loop XPath query field, enter /Customer between quotes on which the loop is based.
  7. In the XPath query column of the Mapping table, enter between quotes the name of the XML node from which you want to collect the staging data, next to the corresponding output column name.
    In this example, three elements that pertain to the Customer entity will be queried: account_num, lname, and fname.