Skip to main content

Watch the Video


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

Load video


In our ongoing Data Vault Friday series, our BI Consultant Julian Brunner delves into a question from the audience that addresses a common challenge.

“One of our sources delivers all the historical data in one batch. So all the records have the same load date. How can I load the data into the EDW properly?”

In this insightful video, Julian shares practical solutions and strategies for loading historical data into an Enterprise Data Warehouse (EDW) when faced with the unique scenario of receiving all records with the same load date. The question prompts a discussion on best practices to ensure proper handling and integration of historical data within the Data Vault framework.

Julian provides valuable insights into the considerations and steps involved in effectively managing historical data loads, offering guidance on maintaining data integrity and accuracy within the EDW.

Meet the Speaker

Julian Brunner

Julian Brunner

Julian Brunner is working as a Senior Consultant at Scalefree and studied Business Informatics and Business Administration. His main focus is on Business Intelligence, Data Warehousing and Data Vault 2.0. As a certified Data Vault 2.0 Practitioner he has 5 years of experience with Business Intelligence solutions and Data Warehouse development with the Data Vault 2.0 standards. He has successfully consulted customers from the banking and consulting sector.

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

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


Leave a Reply