Question on symmetry in 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?

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

makeing a stand for star schema design

Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information

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

Snowflake or Star Schema?

Hi, I am doing some dimensional modelling for a "not for profit" Fundraising Company They solicit Funds from the WEB, Direct Mail and Phone Solitications, etc and all Transactions are stamped with the FundID. The legacy system has all

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.

YES or NO question in the don't ask don't tell regime...

Twinkle the glass..cheer bwt agan2 semua.. Ane newbie nih, newbie di forum plus newbie di lawyer-ing field juga.. kebetulan pengalaman pertama ane dapet kerjaan di Lawfirm litigasi, which is dari sekian banyak case yang gw involved kebanyakan less of

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

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,

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

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

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