Watch the Video
In the latest installment of our enlightening Data Vault Friday series, our CEO, Michael Olschimke, delves into a thought-provoking query posed by a member of our engaged audience.
“We have received the relationship between investor and company with a PostingMonth for the last couple of months. Also, the ownership percentage for the relationship could change over time (see attached Excel for mock data :)). So our question is: should we take the Period as a part of the Investor_Company_Link? If yes, how can we track the relationship changes with Effectivity Satellite? Or do you think Multi-active link satellite is a better choice here?”
Michael meticulously explores the intricacies of modeling investor-company relationships, particularly when faced with dynamic factors such as changing ownership percentages over distinct time periods. He offers valuable insights into the considerations between incorporating Period as part of the Investor_Company_Link and the nuanced application of Effectivity Satellite or Multi-active link satellite to accurately capture and manage the evolving nature of these relationships.
This insightful discussion proves instrumental for data professionals navigating the complexities of representing dynamic relationships within the Data Vault framework.
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!
