Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

star schema designing

2 posters

Go down

star schema designing Empty star schema designing

Post  vinodh Tue Mar 02, 2010 5:23 am

Hi ,
Iam new one to datawarehousing.How to design the star schema.
we have the hr module(OLTP) which has 77 tables.
I have some basic doubts please anyone clear that.

http://en.wikipedia.org/wiki/Star_schema

For ex.
I followed the above link.

Whether OLTP table and dimension table are same or not.
If not,can we create the dimension tables from OLTP tables?

Fact_sales table has date_id,stroe_id,product_id and units_sold.

date_id refers dim_date.
store_id refers dim_Store.
product_id refers dim_product.
but units_sold refers what?


It is a big confusion to me?please anyone help me out that?

vinodh

Posts : 1
Join date : 2010-03-02

Back to top Go down

star schema designing Empty Re: star schema designing

Post  ngalemmo Tue Apr 06, 2010 3:42 pm

Whether OLTP table and dimension table are same or not.

No

If not,can we create the dimension tables from OLTP tables?

Yes

The basic thing to understand about dimensional modeling is the model is divided into facts and measures. Facts represent measurable business events or states and dimensions represent the context for the facts.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum