Hi
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
Solved
Apply Last Changed Date Field Delta Change only on Instance Layer and not on Master Layer
- Data Voyager
Best answer by Ales
Hi
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.
+2- Ataccamer
Hi
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.
Ales
1 person likes this
- Data Voyager
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
1 person likes this
+3- Community Manager
Hi ā
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.