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

Question on symmetry in Star schema
Hi I read Kimball's Data warehouse toolkit and I came across a point that one of the advantages of having star schema is - BI / reporting tools in the market can leverage the symmetrical nature of the star schema. From what I know and I could

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

Estimating star schema & ETL effort
We don't have weeks to go study the systems and the data structures. Unfortunately, we don't have time to understand the data in detail and have a data model, source systems to have a detail estimate of the ETL effort. What is the best way of estimating

Star Schema vs All in one table
Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.

Design of Star Schema?
I am a beginner if a Database is given how we can achieve a Star schema design? Can you please provide me an update. thanks Vel

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

Fact 1:N Dimension with Star Schema
This seems like a very simple problem, but I can't seem to find the answer anywhere. I want to have a situation where a single fact record is associated with 0..N dimension records of a single dimension. An example would be: Fact Table:

Difference between a Cube and a Star
Hello, I have a very basic question. Can anyone please, explain the difference between a cube and a star schema? I studied about Star schema. When I implement it in Oracle Warehouse Builder 11g, I have to create a cube. Am I doing right? regards,

Space savings in Star Vs 3NF
I was curious if anybody had any estimates of the savings in space between a 3NF database and the same Data in a Star Schema? If a 3NF database took up 2.5TB, would the Star be 1.25TB? I was just wondering if there was a rule of thumb about it. In

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.

EDW Design Decision
There is currently a difference of opinion on how the EDW should be structured for ad-hoc reporting. One camp suggests that the dimensional design can easily support both ad-hoc and analytical reporting. While the other suggests that the dimensional