| Dimensional Modelling [message #577273] |
Wed, 13 February 2013 22:01 |
 |
yogeshdhende
Messages: 1
Registered: February 2013
|
Junior Member |
|
|
Hi,
I am working with Stock Exchange data, as per the availability of data, I found 2 dimensions that is
(1)Time
(2)Company
At 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.
[Updated on: Thu, 14 February 2013 00:50] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
