Image of different fees that relate to a transaction
I have a Transactional Fact table showing transactions done by a particular client. I want to relate this fact table to a Dimension Containing Different transaction Fees that might occur on a transaction. Each transaction will be linked to a range of between 1-5 different Transaction Fees which are all listed in different rows within the Transaction Fees Dimension. What is the best way to implement this ? Should I implement something such as Role Play Dimension and have multiple Keys for each type of Transaction Fee ?
Regards, K
I would create a fact table with an atomicity of transaction + transaction fee.
If you know the fees at the time that the transaction is created then you can perform the join between the transaction and its fees during the data load process.
