Estimating star schema & ETL effort

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?

Regarding mapping and effort estimation

Hi, I'm a ETL developer for past 2 years and 2 months. I always have this questions. Please help me to appreciate 1) Whose responsibility is it to give the source to target mapping. Is it etl developer responsibility or a data modeler or designer

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

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

Time Frame & Estimate

I am new BI learner and currently studying kimball datawarehouse toolkit. I have question, How can i estimate a time frame and estimate in terms of working hours for Data Warehouse project. I know we have to go through whole Business dimensional lifecycle

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

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