I am trying to create dimensional model for creating RDBMS. I have to create multiple fact tables. My question is regarding time fact table. I am using date as a fact table. Can I use time as fact table that will be related to date dimension. My purpose is to find sales yearly monthly.
I am trying to create dimensional model for creating RDBMS. I have to create multiple fact tables. My question is regarding time fact table. I am using date as a fact table. Can I use time as fact table that will be related to date dimension. My purpose is to find sales yearly monthly.
I started with one fact table. I need to add measures for this fact table.I am trying to create dimensional model for creating RDBMS. I have to create multiple fact tables. My question is regarding time fact table. I am using date as a fact table. Can I use time as fact table that will be related to date dimension. My purpose is to find sales yearly monthly.