Skip to main content

Watch the Video

YouTube

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

Load video

PGlmcmFtZSB0aXRsZT0iSGlkaW5nIERpbWVuc2lvbiBNZW1iZXJzIiB3aWR0aD0iNTAwIiBoZWlnaHQ9IjI4MSIgc3JjPSJodHRwczovL3d3dy55b3V0dWJlLW5vY29va2llLmNvbS9lbWJlZC90THR0RG4tU3owND9mZWF0dXJlPW9lbWJlZCIgZnJhbWVib3JkZXI9IjAiIGFsbG93PSJhY2NlbGVyb21ldGVyOyBhdXRvcGxheTsgY2xpcGJvYXJkLXdyaXRlOyBlbmNyeXB0ZWQtbWVkaWE7IGd5cm9zY29wZTsgcGljdHVyZS1pbi1waWN0dXJlOyB3ZWItc2hhcmUiIHJlZmVycmVycG9saWN5PSJzdHJpY3Qtb3JpZ2luLXdoZW4tY3Jvc3Mtb3JpZ2luIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+

In our ongoing Data Vault Friday series, our CEO Michael Olschimke addresses a query from the audience, exploring the dynamics of managing data visibility in the DIMENSION information mart.

“How can a record be hidden in the DIMENSION information mart if it is no longer in use? Our Data Warehouse (DWH) features a hierarchy of region, division, and zone, which may undergo splitting or merging multiple times. The challenge is that the deleted event is not signaled from the source side, and only a full refresh captures new hierarchy information. Users desire a consistently current status reflected in both FACT and DIM tables.

1. To handle this, the current relation can be flagged and counted. This approach involves managing the relationship with a counter, allowing for effective tracking and visibility.

2. Additionally, the last relation needs to remain visible in the FACT table, ensuring that historical relationships are retained for reference.”

In this engaging video, Michael elaborates on these strategies, providing insights into maintaining data integrity and visibility within complex hierarchies, while accommodating changes and updates efficiently.

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