Is it normal / best practice to have multiple fact tables but only minimal dimension table(s).
I am new to data modelling and trying to create the best / most efficient data model and it always seems as if I have way to many fact tables.
For context right now I am trying to measures multiple areas of my supply base and have these individual extracts to support this;
Invoices (total paid to supplier)
Demand (Supplier future needs)
Delivery Performance (Supplier on time deliveries)
Ethics (Supplier Ethical incidents)
Cyber (Supplier cyber attacks)
……….
and about 5 others.
The only fact table I have is of my supplier base.. thus becoming my only Dimension table…
is this normal? should I be looking to extract this data differently?
Building the above all joining to the dimension table..