Dimensional Modelling issue

View previous topic View next topic Go down

Dimensional Modelling issue

Post  yogesh.dhende on Thu Feb 14, 2013 3:32 am

Hi,

I am working with Stock Exchange data, as per the availability of data, I found 2 dimensions that is
*(1)Time*
*(2)Company*

In my fact table, some of the fact(measures) are changing based on *Date(Day)* and some of the them are changing based on *Time*

My questions:
[1] : Can a dimension model have only 2 dimensions ?
[2] : Can I make 2 fact tables, *Fact-1* will store measures based on the *Date(Day)* and *Fact-2* will store measures based on the *Time* ?

Please share your valuable suggestions..


Thanks.

yogesh.dhende

Posts : 1
Join date : 2013-02-14

View user profile

Back to top Go down

RE: Dimensional Modelling issue

Post  hkandpal on Thu Feb 14, 2013 10:22 am

Hi,

A dimension model usually has more than one dimension. REgarding your situation where you want Date and TIme, you can have two approaches
1) Store the Date in a date dimension and capture the time directly in the fact .
2) Or Have a date dimenison and a seperate time dimension (the time dimn could be for every hour or minute depending upon how you want to capture the time).

thanks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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