Skip to main content

Hi @Cansu and All

In the event if there is no change in the delta records coming in MDM except one of the Sequence Generated column, is their a way that the date field(Last Changed) gets updated with the date of the new row only on INSTANCE layer and not on the MASTER layer. So, if MDM ingests the delta record in Instance Layer and sees that there are no changes detected on any columns except the sequence column and it has nothing to update the Golden Record already existing then it should update the date field on Instance Layer only and not on Master Layer.

Please let me know if you have any additional questions.

Thank You
Ritesh Ranjan

Hi @ritesh.ranjan ,

can you please clarify what is the Sequence column?

A record is ingested into MDM.Instance layer only if there is at least one attribute/column changed.

Similarly the change is propagated to the Master layer only if there is at least one change on the master record itself i.e. based on your merge rules.

 

In other words if your Golden Record already exists and there is no update on that record even there is a related instance record changed, then it should update the date field on Instance Layer only and not on Master Layer as you mentioned. 

Please check if and how your Golden record changed.

 

Yes I think I agree with the previous comment. If the golden id exists and the update of one of the instances doesnt effect the fields on the golden id, based on the hierarchy youve assigned to the fields, then youre last update date on the golden id prob wont update. unless its maybe an action like a split or rematch that refreshes the master layer in some way. basically anything that would refresh the master layer specifically would be the cause for the last change update on master layer

Reply


Community Terms of Use & ConditionsCookie settings