I am creating a small data warehouse for transactional type data that requires a lot of lookup tables for select criteria. The data will be used for trending these transactions. I've identified about 5 dimensions for the fact table, but my problem is each transaction will require 20 different criteria with lookup descriptions for each transaction. Also, the transaction and the fact table are both at the transaction level and I wonder if I should put all transaction info in the fact table because of this. (Transaction number plus criteria for searches).
Should I create a dimension for the transaction itself along with the 20 description/codes used in the selection criteria, keep all this in the fact table, or snowflake the 20 transaction lookups off the transaction dimension?
Thanks for any help here...