-1

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

Improve this question
0

1 Answer 1

Reset to default
1

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
Improve this answer
7
  • so I need to add a fact table only for one business requirement "count the number of awareness meetings",
    – Guissous Allaeddine
    Commented Apr 11, 2022 at 4:40
  • what if other similar business requirement appears, wouldn't that result in a lot of fact tables without a connection between them, is it normal. please check the picture above, no other dimensions.
    – Guissous Allaeddine
    Commented Apr 11, 2022 at 4:50
  • 1
    I’m not sure what you mean by “fact tables without a connection between them” - why do you think there should be connections between fact tables? If you want to query a measure then that measure needs to be in a fact table - which may. result in a lot of fact tables
    – NickW
    Commented Apr 11, 2022 at 6:14
  • 1
    The reason it looks odd is because your Dims aren’t correct e.g. Department is repeated multiple times so you probably need a Department Dim; Meeting and Awareness Meeting look like the same thing so should be a single Dim (possibly with a type attribute); there are probably a number of other issues you need to address
    – NickW
    Commented Apr 11, 2022 at 11:26
  • 1
    Hi - I'm happy to help with any specific questions you have but I'm afraid you're on your own as far as design reviews go
    – NickW
    Commented Apr 12, 2022 at 14:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.