How to create 2 golden records from matched 2 master records nconditionally?
M
Manoj. chinnaraj
started a topic
11 months ago
Hi,
We are loading the data through the rest API and embedded application UI.
When we are sending the data through the REST API, for specific users, I want to run the matcher, and if 2 master records are found, create 2 golden records and for few other users, if 2 master records are found, merge them and create 1 gold record.
i.e I am creating 2 master records
1. In some cases I want to create 2 golden records of the same
2. In some cases I want to merge and create 1 golden record with latest master record given precedence(using ranking expression in survivorship rule).
Point 2 is already done in our model but we would like to achieve 1 where in some cases if we are creating 2 master records, we shouldn't merge and create 2 golden records.
How can we achieve Point 1?
Thanks,
Manoj Kumar
Best Answer
A
Ambuj Srivastava
said
7 months ago
Hi Manoj.
To achieve the objective #1, it can be achieved by adding and specifying :V_USERNAME variable in match rule's SemQL expression , which means it will execute the match rule only when the :V_USERNAME defined in match rule matches with "SubmitAS" value in RestAPI. Here I used semadmin as the user to execute this match rule.
see screenshot:
For other users this rule won't be executed. But there will be some limitations, please refer to explanation below:
For example:
1.) 2 records (A and B) with same Email ([email protected]) are pushed to xDM using RestAPI from semadmin user, they will be combined and create 1 golden record.
2. ) Another record (C) with Email ([email protected]) is pushed from a user other than semadmin, will create a new golden record rather than getting merged with golden record created in 1.)
3.) Now, if a new record (D) with Email ([email protected]) is pushed from semadmin , which executes the match rule will merge records (A,B,C,D) and form a single golden record.
Objective 1 can only be achieved if the record processed by some other user falling in match rule won't be processed by semadmin to execute the match rule and link all records together.
1 Comment
A
Ambuj Srivastava
said
7 months ago
Answer
Hi Manoj.
To achieve the objective #1, it can be achieved by adding and specifying :V_USERNAME variable in match rule's SemQL expression , which means it will execute the match rule only when the :V_USERNAME defined in match rule matches with "SubmitAS" value in RestAPI. Here I used semadmin as the user to execute this match rule.
see screenshot:
For other users this rule won't be executed. But there will be some limitations, please refer to explanation below:
For example:
1.) 2 records (A and B) with same Email ([email protected]) are pushed to xDM using RestAPI from semadmin user, they will be combined and create 1 golden record.
2. ) Another record (C) with Email ([email protected]) is pushed from a user other than semadmin, will create a new golden record rather than getting merged with golden record created in 1.)
3.) Now, if a new record (D) with Email ([email protected]) is pushed from semadmin , which executes the match rule will merge records (A,B,C,D) and form a single golden record.
Objective 1 can only be achieved if the record processed by some other user falling in match rule won't be processed by semadmin to execute the match rule and link all records together.
Manoj. chinnaraj
Hi,
We are loading the data through the rest API and embedded application UI.
When we are sending the data through the REST API, for specific users, I want to run the matcher, and if 2 master records are found, create 2 golden records and for few other users, if 2 master records are found, merge them and create 1 gold record.
i.e I am creating 2 master records
1. In some cases I want to create 2 golden records of the same
2. In some cases I want to merge and create 1 golden record with latest master record given precedence(using ranking expression in survivorship rule).
Point 2 is already done in our model but we would like to achieve 1 where in some cases if we are creating 2 master records, we shouldn't merge and create 2 golden records.
How can we achieve Point 1?
Thanks,
Manoj Kumar
Hi Manoj.
To achieve the objective #1, it can be achieved by adding and specifying :V_USERNAME variable in match rule's SemQL expression , which means it will execute the match rule only when the :V_USERNAME defined in match rule matches with "SubmitAS" value in RestAPI. Here I used semadmin as the user to execute this match rule.
see screenshot:
For other users this rule won't be executed. But there will be some limitations, please refer to explanation below:For example:
1.) 2 records (A and B) with same Email ([email protected]) are pushed to xDM using RestAPI from semadmin user, they will be combined and create 1 golden record.
2. ) Another record (C) with Email ([email protected]) is pushed from a user other than semadmin, will create a new golden record rather than getting merged with golden record created in 1.)
3.) Now, if a new record (D) with Email ([email protected]) is pushed from semadmin , which executes the match rule will merge records (A,B,C,D) and form a single golden record.
Objective 1 can only be achieved if the record processed by some other user falling in match rule won't be processed by semadmin to execute the match rule and link all records together.
Ambuj Srivastava
Hi Manoj.
To achieve the objective #1, it can be achieved by adding and specifying :V_USERNAME variable in match rule's SemQL expression , which means it will execute the match rule only when the :V_USERNAME defined in match rule matches with "SubmitAS" value in RestAPI. Here I used semadmin as the user to execute this match rule.
see screenshot:
For other users this rule won't be executed. But there will be some limitations, please refer to explanation below:For example:
1.) 2 records (A and B) with same Email ([email protected]) are pushed to xDM using RestAPI from semadmin user, they will be combined and create 1 golden record.
2. ) Another record (C) with Email ([email protected]) is pushed from a user other than semadmin, will create a new golden record rather than getting merged with golden record created in 1.)
3.) Now, if a new record (D) with Email ([email protected]) is pushed from semadmin , which executes the match rule will merge records (A,B,C,D) and form a single golden record.
Objective 1 can only be achieved if the record processed by some other user falling in match rule won't be processed by semadmin to execute the match rule and link all records together.
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 45 topics