In this blog post we will dive into implementing a data vault with more than one source system with the help of WhereScape 3D and WhereScape RED. This blog post is a part of the series: The power of model conversion in data warehouse automation.
If you start to become a more and more proficient data vault modeler you will face the challenge of designing a data vault with more than one data source.
Primary data source
For this example we will use the Northwind database and the AdventureWorks database as they both contain an employee entity which will act as our example. Let’s first design the employee entity with the Northwind data source and take it from there.