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

GETRECORD Operation

GETRECORD Operation

The GETRECORD operation gets the matching records for the input data from the repository. Before you run the GETRECORD operation, run the GETRECORDLAYOUT operation to get the layout for the input data in the JSON format based on the configuration file. Based on the layout, you can specify the input data for the GETRECORD operation.
Run the
run_client.sh
script located in the following directory to perform the GETRECORD operation:
/usr/local/mdmbdrm-<Version Number>
Use the following command to run the
run_client.sh
script:
run_client.sh --config=configuration_file_name --rule=matching_rules_file_name --operation=GETRECORD --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.
--rule
matching_rules_file_name
Absolute path and file name of the matching rules file that you create.
--operation
GETRECORD
Type of operation that you want to perform. Specify GETRECORD.
--input
input_file_name
Absolute path and name of the input JSON file that contains the input data.
--outputfile
output_file_name
Optional. Absolute path and name of the output JSON file to which you want to load the record layout.
For example:
run_client.sh --config=/usr/local/tree/configuration.xml --operation=GETRECORD --input=/usr/local/tree/input.json --rule=usr/local/conf/matching_rules.xml --outputfile=/usr/local/tree/output.json
The following sample body lists the input records for which you want to retrieve the matching records:
{ "keyDataList":[ { "SOURCE":"SAP", "ID":"41" }, { "SOURCE":"Salesforce", "ID":" 42" }, { "SOURCE":"SAP", "ID":"201" }, { "SOURCE":"Baan", "ID":"182" }, { "SOURCE":"Airtel", "ID":"219" } ], "searchToken":-1, "pageLimit":10, "pageOffset":0, "totalCount":0, "debug":false, "resultCount":0, "messages":{ } }
The following sample output shows the matching records that the GETRECORD operation retrieved:
{ "record":{ }, "bulkRecord":[ { "keyData":{ "SOURCE":"SAP", "ID":"41" }, "record":{ "SALARY":"10001", "CITY":"Valencia", "ADDRESS":"ChurchStreet", "PHONE":"08040201001", "SOURCE":"SAP", "ID":" 41", "PINCODE":"", "DOJ":"2012", "NAME":"Nani", "COMPANY":"Valencia F.C.", "AGE":"30" } }, { "keyData":{ "SOURCE":"Salesforce", "ID":" 42" }, "record":{ "SALARY":"10000", "CITY":"Valenci", "ADDRESS":"ForumMall", "PHONE":"08040201002", "SOURCE":"Salesforce", "ID":" 42", "PINCODE":"560104", "DOJ":"", "NAME":"Nani", "COMPANY":"", "AGE":"29" } }, { "keyData":{ "SOURCE":"SAP", "ID":"201" }, "record":{ "SALARY":"10001", "CITY":"Bangalore", "ADDRESS":"Bagmane TechPark", "PHONE":"08040201000", "SOURCE":"SAP", "ID":" 201", "PINCODE":"560103", "DOJ":"2012", "NAME":"John Smith", "COMPANY":"INFA", "AGE":"30" } } ], "searchToken":-1, "pageLimit":10, "pageOffset":0, "totalCount":3, "debug":false, "resultCount":3, "messages":{ } }

0 COMMENTS

We’d like to hear from you!