Four Stars

MDM: Foreign key management and Staging Validation

Hello,

 

I have 2 records in the staging linked by a foreign key (For Example to simplify the problem: Entity "Person" and Entity "Location" linked by a foreign key "LocationId" in the table Person).

 

When validating the staging, The Location record is merged with another record (Using Matching Rules) and it's key is modified to become the one of the golden record in the master database...

 

The problem is that the Person record still have the old value of the Location Id and, during the staging validation, the person record is not sent to the Master database because it has a foreign key integrity error...

 

I thought that Talend MDM, during staging validation, would automatically updates foreign keys if they change during Staging Validation, but it's not the Case...

 

Can you please help to find a solution on how to fix this problem of foreign key integrity error during Staging Validation and what's the best practices.... Do we need to have a 'before saving process' in the Location entity that will update foreign keys in Staging... Or I heard about lookup tables for foreign keys (but I haven't found any documentation on that, so I don't know how it works...)

 

Thank you

Tags (1)
1 REPLY
Moderator

Re: MDM: Foreign key management and Staging Validation

Hi,

Could you please post your setting screenshots on forum which will be helpful for us to understand your issue? And which is talend MDM product you are using?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.