1 or 2 Dimensions - Customer & Shipping Address
I have read the Toolkit book and am doing a little dimensional modelling exercise, but I have come across an issue which I am not sure about. I have a Customer dimension but I am not sure whether or not to include the shipping address in the Customer

Loading Future Dated Rows to Dimensions
Hi All, Our OLTP system supports effective dated concept. So users can enter Future Dated Rows also. And in our Warehouse we have both Type1 Dimesnions and Type2 Dimensions. When loading the data to Type1 dimesnions, if we load future dated row

relating 2 existing dimensions combined to a fact table
given: * 1 existing sales fact table; > 1.500.000.000 records * 1 existing product dimension; >= 300.000 records * 1 existing store dimensions; >= 1.000 records required: * 3 new attributes, defined by the combination of a certain store an

Same attribute in multiple dimensions or Create new dimension?
Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

Conforming Dimensions - Standardising, De-duplicating and Suvivorship
Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would

Database Partitioning and Dimensions without the distribution key
We are upgrading our data warehouse platform, and now have the option to partition the database across CPUs as well as partitioning tables themselves. For database partitioning, there is a performance impact if the data from tables to be joined is not

A fact table surrounded by a lot of references tables
I am reviewing a design which is about to be implemented after build. There is a fact table with 17(!!) foreign keys. 14 of these keys are two-letter codes pointing to reference-tables (as we call them). A reference table consist of codes with

How to manage Conformed dimensions
Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Unsure about relationship with Slowly Changing dimensions.
Hi Sorry datawarehouse newbie question! I have many years experience with relational databases but my head is not yet around the dimensional model. I am not sure how to maintain the relationship between Fact and Type 2 Dimension. i.e if a new row is

Best Praticte for inserting fact and linking to dimensions
Hi all, is it allowed to have null values in fact table for some dimensions foreign keys ? Exemple : DateDimFk DimFk1 DimFk2 50 (coming from business system 1) DateDimFk null DimFk2 50 (coming from business system 2) or do i have to create a

"Shared Dimensions" ... Complicates Usage of Data Warehouse??
Question about 'Shared' dimensions. I have the following shared dimensions: Dim_Shared_Status & Dim_Shared_StatusType Dim_Shared_Status contains: [Id], [StatusTypeId], [Name] Dim_Shared_StatusType contains: [Id], [Name] Now

Data Marts, Conformed dimensions and Data Warehouse
Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I

Snapshot Dimension & Fact tables
We are currently designing a logical multidimensional model from an OLTP tables.Dimension tables have monthly snapshot because some of or all the attributes might change on monthly basis.The same situation for the fact table has monthly snapshot. I kno

Junk Dimension Naming
What do you call your junk dimensions? Do you use "junk" in the dimension name? Junk implies garbage so I don't like using it. Most dimensions are easily named since they represent a single person, place, thing, concept, or event. Junk

What kind of roleplay do you do?
Do you have experience in roleplay? If so, what kind? And if not, then what do you want to do? Personally, I never went for any of that realistic stuff. I got boring. My friend and I picked a few characters from fandoms and just played with silly,