Skip to main content

Watch the Video

YouTube

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

Load video

PGlmcmFtZSB0aXRsZT0iTlVMTCBCdXNpbmVzcyBLZXlzIiB3aWR0aD0iNTAwIiBoZWlnaHQ9IjI4MSIgc3JjPSJodHRwczovL3d3dy55b3V0dWJlLW5vY29va2llLmNvbS9lbWJlZC9aS09jTlEzTEkwMD9mZWF0dXJlPW9lbWJlZCIgZnJhbWVib3JkZXI9IjAiIGFsbG93PSJhY2NlbGVyb21ldGVyOyBhdXRvcGxheTsgY2xpcGJvYXJkLXdyaXRlOyBlbmNyeXB0ZWQtbWVkaWE7IGd5cm9zY29wZTsgcGljdHVyZS1pbi1waWN0dXJlOyB3ZWItc2hhcmUiIHJlZmVycmVycG9saWN5PSJzdHJpY3Qtb3JpZ2luLXdoZW4tY3Jvc3Mtb3JpZ2luIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+

In our continuous Data Vault Friday series, our CEO, Michael Olschimke, takes a moment to delve into a thought-provoking question raised by our audience.

“Does the Business Key should be a not null column at the source?”

This succinct yet critical query is the focus of this brief but insightful video. Michael engages with the nuances of the business key, exploring whether it should be a mandatory, not-null column at the source. As he unpacks the considerations, the audience gains valuable insights into the implications and potential advantages of enforcing the not-null constraint on the business key.

For those seeking clarity on best practices surrounding business key management, this video provides concise guidance.

Meet the Speaker

NULL Business Keys in Data Vault

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