Skip to main content

developerWorks >  Information Management  >  Forums  >  InfoSphere Master Data Management Server  >  developerWorks

SDP (Perfect Match) behavior on Update Party    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 9 - Pages: 1 - Last Post: Oct 25, 2009 12:26 PM Last Post By: Evyatar
Evyatar

Posts: 24
Registered: Jun 11, 2009 02:19:21 AM
SDP (Perfect Match) behavior on Update Party
Posted: Oct 19, 2009 05:45:10 AM
 
Click to report abuse...   Click to reply to this thread Reply
Let's say we have two Party records:
Person A with First Name "aaa", Last Name "bbb", DoB 01/01/1980 and a full Address X (Party ID 1)
Person B with First Name "ccc", Last Name "ddd", DoB 01/01/1970 and a full Address Y (Party ID 2)

Now we get an updateParty request for Person B with all the relevant idPK and LastUpdateDate values.
However, the request is to change the values of Person B to be exactly like Person A.

According to the documentation, the parties should be automatically merged (A1 match).
What would happen in terms of DB records and IDs?
Should we get in the updateParty (for Person B) response Party ID 1 (of Person A)?

Thanks in advance,
Evyatar
mdm_newbie

Posts: 9
Registered: May 09, 2009 11:52:45 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 19, 2009 01:27:16 PM   in response to: Evyatar in response to: Evyatar's post
 
Click to report abuse...   Click to reply to this thread Reply
When the updateParty request is received for Person B with all critical data elements same as Person A (leading to A1 match), the Person B will be updated. Once updated, suspects are reidentified, therefore, Person A and Person B are A1 matches. An A1 suspect record is created in the SUSPECT table.
Based on the auto collapse rule configured, you may be able to see a brand new party created in the database due to the collapse of Person A and Person B, with Person A and Person B party records inactivated.

Thanks,
Vj
Evyatar

Posts: 24
Registered: Jun 11, 2009 02:19:21 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 20, 2009 08:17:42 AM   in response to: mdm_newbie in response to: mdm_newbie's post
 
Click to report abuse...   Click to reply to this thread Reply
Hey,

That sounds good.
How do I verify that the auto collapse rule is configured?

In our implementation there's not going to be any manual handling at the moment (SDP would result either a perfect match or a new party and never a suspect).

Thanks,
Evyatar
mdm_newbie

Posts: 9
Registered: May 09, 2009 11:52:45 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 20, 2009 11:56:12 AM   in response to: Evyatar in response to: Evyatar's post
 
Click to report abuse...   Click to reply to this thread Reply
Check Rule 11. Out-of the-box it is configured to use AutoCollapsePartiesProductionExtRule class which does not do anything.
Set the Rule 11 to execute AutoCollapsePartiesExtRule class instead. This might do the auto-collapse.

Thanks,
Vj
Evyatar

Posts: 24
Registered: Jun 11, 2009 02:19:21 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 21, 2009 11:16:47 AM   in response to: mdm_newbie in response to: mdm_newbie's post
 
Click to report abuse...   Click to reply to this thread Reply
Hey,

I did what you said, assuming you meant to running the following SQL command -
update JAVAIMPL set JAVA_CLASSNAME ='com.dwl.tcrm.externalrule.AutoCollapsePartiesExtRule',last_update_dt = current_timestamp where EXT_RULE_IMPL_ID = 1011;

However, it seems that the transaction doesn't go into that rule.
I think it might be related to the fact that the procedure of "re-identifying suspects" doesn't happen either.
We have in configelement /IBM/Party/CriticalDataChangeProcessing/enabled set to "false", which enables "free" update of critical data.
Is it related?
(I'm asking that because it seems like the Reidentifying process happens after approving CDC...)
What is the solution in that case?

Thanks in advance,
Evyatar
mdm_newbie

Posts: 9
Registered: May 09, 2009 11:52:45 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 21, 2009 01:22:32 PM   in response to: Evyatar in response to: Evyatar's post
 
Click to report abuse...   Click to reply to this thread Reply
Check if there are any entries in the CONTACTCDC table related to the PartyId being updated.
If there are entries, this means Critical Data Change Processing is not allowed.
Create a custom rule class eg: CustomCDCAllowRule.

public Object execute(Object input, Object componentObject)
throws Exception {
if (logger.isFineEnabled()) {
logger.fine(debugStr);
}
return new Boolean(false);
}
mdm_newbie

Posts: 9
Registered: May 09, 2009 11:52:45 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 21, 2009 01:25:04 PM   in response to: Evyatar in response to: Evyatar's post
 
Click to report abuse...   Click to reply to this thread Reply
Check if there are any entries in the CONTACTCDC table related to the PartyId being updated.
If there are entries, this means Critical Data Change Processing is not allowed.
Create a custom rule class eg: CustomCDCAllowRule and return Boolean True.

public Object execute(Object input, Object componentObject)
throws Exception {
return new Boolean(true);
}

Configure it as Rule 124. This will allow CDC to be processed real time.

Thanks,
Vj
mdm_newbie

Posts: 9
Registered: May 09, 2009 11:52:45 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 21, 2009 01:28:46 PM   in response to: mdm_newbie in response to: mdm_newbie's post
 
Click to report abuse...   Click to reply to this thread Reply
Evatayar,

Pls ignore Post# 6 in this thread..My Mistake..

Thanks,
Vj
Evyatar

Posts: 24
Registered: Jun 11, 2009 02:19:21 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 22, 2009 04:07:45 AM   in response to: mdm_newbie in response to: mdm_newbie's post
 
Click to report abuse...   Click to reply to this thread Reply
There are no records in CONTACTCDC, as we allow all changes (configelement "/IBM/Party/CriticalDataChangeProcessing/enabled" = false).

Are you suggesting to change that configelement value to "true" and then create the changes you mentioned?

Regards,
Evyatar
Evyatar

Posts: 24
Registered: Jun 11, 2009 02:19:21 AM
Re: SDP (Perfect Match) behavior on Update Party
Posted: Oct 25, 2009 12:26:05 PM   in response to: Evyatar in response to: Evyatar's post
 
Click to report abuse...   Click to reply to this thread Reply
I will rephrase -

When a Party is updated to have the exact same details as an existing Party, we want to activate Auto Collapse functionality.

Can someone please assist with detailed instructions?

Thanks in advance,
Evyatar
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums