I am developing a data warehouse. I have a question in order to design a star schema for the data warehouse.
The data I am using for my project is changing at each 5-minute interval of time.
So, I have 288 records for a particular date.
Now, I have to prepare the date and time dimension for the same.
My first question: Should I have seperate dimension tables for Date and Time data? Or, there will be a single DateTime dimension?
Second Question: What would be the dimension attributes of these date and time dimension tables?
Basically, my fact table will contain data varying according to space, time and day. How should I prepare a Star schema for it?