What problem is the pattern looking to solve
How do we model data from multiple systems when they store copies of the same business concept (Customer, Person, Organisation, Product etc), using a Data Vault modeling approach.
A generalised design which can be applied to solve the problem given the context
A disucssion on when this pattern could be applied
This pattern should only be applied when you can guarantee all source applications are using shared id’s for concepts.
This means that the id of the “A1” for the “ABC123” organisation in the CRM source applications is the same id of “A1” for the “ABC123” supplier in the FMIS source application.
Unless there is a set of robust data exchange patterns being enforced across the source applications, there is always the potential for an id clash and one of the other Golden Record patterns should be adopted.
The likely consequences of adopting this pattern
Other patterns that are similair to this pattern or reliant upon it
Ask us to complete this pattern
Get in touch and let us know you would like us to complete this pattern next