Dimensions Directly Tied to Facts vs. Snowflaking

Specify acceptable Snowflaking scenarios

Can someone please specify acceptable snowflaking scenarios. - Thanks in advance bi_at_nj

I've got two related questions. Question 1: Building an insurance data warehouse, you have a DimPolicy table (for the insurance policy) and a FactPolicyTransaction table (for the transactions on that policy). There is an insurance agent that is

Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table

Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table

Multiple facts in a fact table

One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us

Facts or Dimension Attributes?

My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Have You Scrutinized The Facts About Juicing, Healthy Diet, Juicing For Better Health

By David Wellsford We are all very aware today the benefits of good nutrition, and the vitamins, and minerals that are necessary for our health. What do we know about juicing, healthy diet, juicing for better health? What does juicing mean? Making

16 Amazing Science Facts

1. Fingernails grow four times faster than toenails 2. Right handed people live, on average, nine years longer than left-handed people 3. If you rub an onion on your foot within 30 60 minutes you will be able to taste it this is because it

Honeycomb, Nielsen shows Android tied iOS and Blackberry

We all knew this was happening. Blackberry OS has been dropping out of favor between smartphone users for a while. iOS has been pretty flat for a while too. Meanwhile, Android went from infancy to full maturity in the 18 month period the graph below

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

Random Facts October

They grow up so fast! RF: The staff is organising a birthday party for the forum, but don't tell anyone!

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

your interesting facts

so basically you put interesting facts about yourself such as something really good or really bad you have done,something really good or really bad that has happened to you, or just something you want to share about yourself.you can also put any