Confusion - star, snowflake, bridge table

Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?

Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?

Many to Many Confusion

Hi, Just wanted to know how we can overcome or resolve Many to Many Relationship in DWH. Vishal

Converting Snowflake to Star

Not sure how to approach this. I have inherited an existing design with a fact table representing Tenants at an apartment property, and a dimension representing the property. Tenant Fact: PropertyKey (FK) DateKey

Large number of snowflake code tables per dimension

Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Populating Bridge Tables Technics

Hi, I'm trying to figure out which are the best practises concerning the populating and maintaining bridge tables using ETL tools. I have a transaction fact tables, and each row of it involves 1 or more rows of Departement dimension table. I gues

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Some Practical Challenges

Hi All I am facing some challenges in my dimensional modeling and most of these are covered in many books too.But i have practical limitation for that 1st Challenge :Unbalanced Hierarchy In one of the dimension we are tracking employees and their

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

4 & 5 Star Words For Tender

http://www.facebook.com/topic.php?topic=1384&uid=150606774949758

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

King of the Hill

RIP to this great show. It really grinds my sprockets that it got canned... to make matters worse I heard the Clevland show is replacing its time slot if thats true the fox sundaynight lineup will be almost all Seth McFarlane shows which is kinda pointles

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

Porn Star Name Generator (blame ChrissyBoy for this one!)

OK, the idea came from ChrissyBoy on the Get To Know You thread, so I accept no credit - or blame! But what is your perfect Porn Star name? You can find out here: EDIT: This link was acting funny so I removed it...see next post for new one! I am