Home » Developer & Programmer » Data Integration » Dimensional Modelling
Dimensional Modelling [message #577273] Wed, 13 February 2013 22:01
Messages: 1
Registered: February 2013
Junior Member

I am working with Stock Exchange data, as per the availability of data, I found 2 dimensions that is

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..


[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: Sun May 19 09:47:02 CDT 2024