Snowflake or Star Schema?

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?

Employee compensation - Star or Snowflake?

I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses. Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have

Start Schema vs Snow flake schema

In my organisation we are on a way to implement data warehouse and data mart for sale. we have one dimension City/District/Store. 1. Store name can be split/merge from one district to other in next quarter. 2. there is possibility of changing City nam

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

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

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

4 & 5 Star Words For Tender

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

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

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

Blue Star Line

My Forum, Blue Star Line is based around the game Ship Simulator 2008. The main idea behind the forum is to make the simulator more realistic, by adding in the effect of being part of a company, like Blue Star Line. We have many divisions in our forum,

How to become a soccer player?

I LOVE soccer and I want to pursue my dream of being a professional or possibly national soccer player. I've been playing soccer for 5 years and I think soccer is my thing. I'm planning to play soccer in university team. Can I become a

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:

Dancing with the Stars, season 11

Meet the new cast! Michael Bolton has sold more than 53 million records, released 18 studio albums, won multiple Grammy awards for Best Male Vocalist and countless other honors, all while selling out arenas worldwide. In 2002, the singer-songwriter