Skip to main content

Watch the Video

YouTube

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

Load video

PGlmcmFtZSB0aXRsZT0iQ2FwdHVyaW5nIENEQyBGbGFncyBpbiBEYXRhIFZhdWx0IiB3aWR0aD0iNTAwIiBoZWlnaHQ9IjI4MSIgc3JjPSJodHRwczovL3d3dy55b3V0dWJlLW5vY29va2llLmNvbS9lbWJlZC9RWGRBWGJSRWE5MD9mZWF0dXJlPW9lbWJlZCIgZnJhbWVib3JkZXI9IjAiIGFsbG93PSJhY2NlbGVyb21ldGVyOyBhdXRvcGxheTsgY2xpcGJvYXJkLXdyaXRlOyBlbmNyeXB0ZWQtbWVkaWE7IGd5cm9zY29wZTsgcGljdHVyZS1pbi1waWN0dXJlOyB3ZWItc2hhcmUiIHJlZmVycmVycG9saWN5PSJzdHJpY3Qtb3JpZ2luLXdoZW4tY3Jvc3Mtb3JpZ2luIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+

In our ongoing series, Michael Olschimke, our CEO, engages with a viewer’s question:

“If you get CDC data and insert/update/delete flag, then would you split it to separate satellite table or leave it on regular sat?”

The specific query revolves around handling CDC (Change Data Capture) data, particularly when faced with insert/update/delete flags. The viewer seeks guidance on whether to split this data into separate satellite tables or retain it within a regular satellite.

In response, Michael addresses the intricacies of managing CDC flags within the Data Vault framework. He explores the pros and cons of both approaches, providing valuable insights into the considerations that influence the decision-making process. This session offers practical advice on structuring satellite tables to effectively capture and utilize CDC flags in a Data Vault environment.

For those grappling with the nuances of integrating CDC data seamlessly into their Data Vault setup, Michael’s expertise provides clarity and actionable recommendations, making this episode of Data Vault Insights a valuable resource.

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