Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Relate 360
  3. Linking Batch Data
  4. Tokenizing Batch Data
  5. Processing Streaming Data
  6. Creating Relationship Graph
  7. Loading Linked and Consolidated Data into Hive
  8. Searching Data
  9. Monitoring the Batch Jobs
  10. Troubleshooting
  11. Glossary

User Guide

User Guide

Get Preferred Record Operation

Get Preferred Record Operation

The Get Preferred Record operation gets the preferred record for the specified cluster. The operation can also generate the preferred record for the cluster in the run time based on the specified consolidation rules.
Before you perform the Get Preferred Record operation, perform the Get Preferred Record Layout operation to get the layout for the preferred record. Based on the layout, you can configure the input parameters for the Get Preferred Record operation.
Run the
run_client.sh
script located in the following directory to perform the Get Preferred Record operation:
/usr/local/mdmbdrm-<Version Number>
Use the following command to run the
run_client.sh
script:
run_client.sh --config=configuration_file_name --operation=GETPREFERREDRECORD --input=input_file_name [--outputfile=output_file_name]
The following table describes the options and arguments that you can specify to run the
run_client.sh
script:
Option
Argument
Description
--config
configuration_file_name
Absolute path and file name of the configuration file that you create.
--operation
GETPREFERREDRECORD
Type of operation that you want to perform. Specify GETPREFERREDRECORD.
--input
input_file_name
Absolute path and name of the input JSON file that contains the layout for the preferred record.
--outputfile
output_file_name
Optional. Absolute path and name of the output JSON file to which you want to load the preferred record of the cluster.
For example:
run_client.sh --config=/usr/local/tree/configuration.xml --operation=GETPREFERREDRECORD --input=/usr/local/tree/input.json --outputfile=/usr/local/tree/output.json
The following sample response shows the preferred record for the specified cluster:
{ "getResults":[ { "keyData":{ "SOURCE":"SAP", "ID":"41" }, "record":{ "ROW_RULE":"SINGLE_RECORD_CLUSTER", "LMT_CREATE_DATE":"20181221090143", "PHONE":"08040201001", "LMT_DIRTY_IND":"0", "PINCODE":"", "NAME":"Nani", "COMPANY":"Valencia F.C.", "COLUMN_RULE":"ALL:SINGLE_RECORD_CLUSTER", "SALARY":"10001", "CITY":"Valencia", "CLUSTERNUMBER":"e219cfe0-8aa9-451e-8ee0-99a75d9c7ed3 ", "ADDRESS":"ChurchStreet", "SOURCE":"SAP", "ID":" 41", "DOJ":"2012", "AGE":"30" } }, { "keyData":{ "SOURCE":"Salesforce", "ID":" 42" }, "record":{ "ROW_RULE":"SINGLE_RECORD_CLUSTER", "LMT_CREATE_DATE":"20181221090143", "PHONE":"08040201002", "LMT_DIRTY_IND":"0", "PINCODE":"560104", "NAME":"Nani", "COMPANY":"", "COLUMN_RULE":"ALL:SINGLE_RECORD_CLUSTER", "SALARY":"10000", "CITY":"Valenci", "CLUSTERNUMBER":"deccf2b2-6585-4c0f-ae46-9b95b84a1de2 ", "ADDRESS":"ForumMall", "SOURCE":"Salesforce", "ID":" 42", "DOJ":"", "AGE":"29" } }, { "keyData":{ "SOURCE":"SAP", "ID":"201" }, "record":{ "ROW_RULE":"DEFAULT_RULE_MAX_COLUMN_VALUES", "LMT_CREATE_DATE":"20181221090143", "PHONE":"08040201000", "LMT_DIRTY_IND":"0", "PINCODE":"560103", "NAME":"John Smith", "COMPANY":"INFA", "COLUMN_RULE":"CITY:RANK", "SALARY":"10001", "CITY":"Bangalore", "CLUSTERNUMBER":"250ef6e6-ec3d-40fc-87ea-7ca63a0c19d8 ", "ADDRESS":"Bagmane TechPark", "SOURCE":"SAP", "ID":" 201", "DOJ":"2012", "AGE":"30" } } ], "rowRules":{ "rowRule":[ ] }, "columnRules":{ "columnRule":[ ], "columnGroup":[ ] }, "searchToken":-1, "pageLimit":10, "pageOffset":0, "totalCount":3, "debug":false, "resultCount":3, "messages":{ "Response Time":"75 ms" } }

0 COMMENTS

We’d like to hear from you!