Home » Developer & Programmer » Data Integration » Dimensional Modelling
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

Previous Topic: Error While deploying Mapping
Next Topic: Find the log
Goto Forum:
  


Current Time: Thu Mar 28 17:27:22 CDT 2024