Thanks for coming back.

If we start with dimensions, are we saying all dimensions only contain unique distinct records, for example I have 10 customers and 15 products, does this mean my DimCustomer dimension will only have 10 distinct records for each customer and DimProduct 15 rows for each product? with both containing a business key to join back to the fact table which collects all the record transactions.

Thanks