Watch the Video
In our ongoing Data Vault Friday series, our CEO Michael Olschimke addresses a thought-provoking question raised by our audience regarding data warehouse management.
“In our data warehouse currently, there are 3 hubs. Now, business users are seeking new information from another table, one that contains the results of tests conducted on the business objects represented by the 3 hubs. This new table features foreign keys corresponding to the 3 hubs. Interestingly, per row, only 1 foreign key is filled, followed by the associated test results.
To address this scenario, we considered attaching a satellite to each of the hubs and populating it with data only if the relevant foreign key is set. Another option we explored was modeling it as a link between the three hubs. However, given that there is no other table depending on it, we are inclined to lean towards option 1, attaching satellites to the hubs.”
This nuanced discussion on handling data relationships and the potential risks associated with overloading links is further explored in detail in the accompanying short video.
Meet the Speaker
Michael Olschimke
Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!
