Skip to main content

Watch the Video

YouTube

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

Load video

PGlmcmFtZSB0aXRsZT0iRGF0YSBWYXVsdCBQb2ludCBJbiBUaW1lIChQSVQpIFRhYmxlcyIgd2lkdGg9IjUwMCIgaGVpZ2h0PSIyODEiIHNyYz0iaHR0cHM6Ly93d3cueW91dHViZS1ub2Nvb2tpZS5jb20vZW1iZWQvclJ3YWZwWkxXdzQ/ZmVhdHVyZT1vZW1iZWQiIGZyYW1lYm9yZGVyPSIwIiBhbGxvdz0iYWNjZWxlcm9tZXRlcjsgYXV0b3BsYXk7IGNsaXBib2FyZC13cml0ZTsgZW5jcnlwdGVkLW1lZGlhOyBneXJvc2NvcGU7IHBpY3R1cmUtaW4tcGljdHVyZTsgd2ViLXNoYXJlIiByZWZlcnJlcnBvbGljeT0ic3RyaWN0LW9yaWdpbi13aGVuLWNyb3NzLW9yaWdpbiIgYWxsb3dmdWxsc2NyZWVuPjwvaWZyYW1lPg==

In our continuing series, our CEO, Michael Olschimke, delves into a thought-provoking question raised by an audience member:

“I’m trying to grasp why the majority of Point-In-Time (PIT) table illustrations do not incorporate tracking satellites to accurately reconstruct the timeline for a business key. For example, I have three snapshots for business key 001 stored in satellite1. This seems inaccurate as the record was deleted from the source. Why does this prevail?”

Michael engages in a detailed discussion on the concepts of Point-In-Time (PIT) and Effectivity Satellites, shedding light on the importance of incorporating tracking satellites for maintaining data integrity and timeline accuracy in data warehousing practices.

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