Start Schema vs Snow flake schema

How to handle a change in the child dimension in snow-flake schema?

I have a Project dimension table and a Project Manager dimension table. Each Project has one Project Manager. The Project Manager table has a Project_Manager_Key (the surrogate key), a Project_Manager_ID (the business key), a Project_Manager_Location

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?

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

Snowflake scenarios

Had seen a few places where dimensions were snowflaked. But how do we figure out that these snowflaked dimensions are justified? Specify scenarios where snowflaking is acceptable. Thanks in advance, bi_at_nj

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

DWT 2nd ed insurance schema

DWT 2nd edition chapter 15 is about insurance. Is the schema described available in more detail anywhere?

Template Star Schemas

All, Is there a website or a book that we can use that has Template Star Schemas (Starter Kits) for different industries. I already have Dr. Kimball's Data Warehouse toolkit book. Is there any other material (web or book) besides the one? Thanks!

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

Designing for columnar database

We are implementing our EDW layer in a highly normalized manner on a columnar database. The current design approach for the transactional or business event data is to have single measure/value column table (plus the keys) to hold all the values and have

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.

dreading the snow

Is anyone else waiting for the snow to come? My DH is away so all shoveling is up to me which I don't mind except I have my 2 year old DD. I am so ready for spring!

My first bike (CB 750 F1)

I think it's a good time to make a 'project-topic'. I bought this bike 3 weeks ago. The plan is to convert it to a caferacer. As you see I have a lot of questions, but hey, that's where a forum is for right? The evening I bought

How to remove System Tool 2011

System Tool 2011 removal Note: We disclaim any affiliation with the creators of System Tool 2011 rogue antivirus. Welcome to the removal guide for System Tool 2011. This is to be considered a self-help guide, and the Security Team at this site does