Tag

SSIS

Data Warehousing Tip #6 – Use a consistent unknown member key

28th January 2019
Author: [Chris Jenkins](/content/author/chrisbidesign-uk/ "Posts by Chris Jenkins"/index.html)
Category: Data Warehousing

In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And I’ll show you a couple of ways of going about implementing a consistent approach. Each of your dimensions should have an unknown member key. The aim of which is to ensure all source data flows...

Read More