I have a modeling question. Everything the BMV does starts with a transaction. license renewal, registration renewal, title amendment, etc.. and I currently have a transaction type dimension that shows transaction counts by this dimension.
I keep getting hung up on the information that is only relavant to the individual transaction types.
Example: I have the following requests
# of active licenses set to expire by month
# of active registrations set to expire by month
Title turnaround time (transaction start date to title process date)
license:
license expiration date
active_flag
title:
title process date
active_flag
registration:
registration expiration date
vehicle_uid
plate_uid
active_flag
All of this information starts with a transaction, so they have the same grain. So is it correct design to have completely unrelated fields in one fact table?
-- Nick