Skip to main content

Watch the Video

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

PGlmcmFtZSB0aXRsZT0iRGVwZW5kZW50IENoaWxkIExpbmtzIHdpdGggU3RhdHVzIFRyYWNraW5nIiB3aWR0aD0iNTAwIiBoZWlnaHQ9IjI4MSIgc3JjPSJodHRwczovL3d3dy55b3V0dWJlLW5vY29va2llLmNvbS9lbWJlZC9fejBOWE1vbmNxUT9mZWF0dXJlPW9lbWJlZCIgZnJhbWVib3JkZXI9IjAiIGFsbG93PSJhY2NlbGVyb21ldGVyOyBhdXRvcGxheTsgY2xpcGJvYXJkLXdyaXRlOyBlbmNyeXB0ZWQtbWVkaWE7IGd5cm9zY29wZTsgcGljdHVyZS1pbi1waWN0dXJlOyB3ZWItc2hhcmUiIHJlZmVycmVycG9saWN5PSJzdHJpY3Qtb3JpZ2luLXdoZW4tY3Jvc3Mtb3JpZ2luIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+

In our ongoing series, CEO Michael Olschimke addresses a viewer’s inquiry:

“I have a source with multiple records for one BK. I model this as a hub and a satellite with a dependent child key. As a status tracking satellite only tracks the parent key hub; how can I track the deletes of the records with the dependent child?”

The viewer presents a challenge tied to a source containing multiple records for a single Business Key (BK). Their current modeling involves a hub and a satellite with a dependent child key. However, they are grappling with how to effectively track the deletions of records associated with the dependent child, especially when a status tracking satellite typically tracks only the parent key hub.

Michael engages with this query, shedding light on strategies and best practices related to Dependent Child Links in the context of Data Vault modeling. He offers insights into addressing the specific scenario described by the viewer, providing practical guidance on tracking deletions in situations where dependent child keys are involved.

This episode serves as a valuable resource for Data Vault practitioners grappling with similar challenges in their modeling endeavors. Michael’s expertise provides clarity on how to navigate the intricacies of tracking deletions effectively 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!

Get Updates and Support

Please send inquiries and feature requests to [email protected]

For Data Vault training and on-site training inquiries, please contact [email protected] or register at www.scalefree.com.

To support the creation of Visual Data Vault drawings in Microsoft Visio, a stencil is implemented that can be used to draw Data Vault models. The stencil is available at www.visualdatavault.com.

Scalefree

Leave a Reply