How to fit a separate table in data warehouse model?

165 views Asked by At

I have a table named AWARENESS_MEETINGS with name and date of the meeting as an attributes, it's not related to any other table in the database. I am designing a data warehouse model, I can't fit it into the model its only related to the date dimension, and I can't determine if it's a fact or dimension table, the only business question related to the table is the count of the AWARENESS_MEETINGS by time.

EDITE: enter image description here

EDITE 2:

enter image description here

1

There are 1 answers

7
NickW On BEST ANSWER

If you have a business requirement to count the number of awareness meetings then you would need:

  • a fact table to hold the counts
  • a meetings dimension to hold the meeting name
  • a date dimension
  • any other dimensions needed to slice/dice/aggregate the fact table