catering multiple transaction ids in one column
Page 1 of 1
catering multiple transaction ids in one column
Hello
I have a scenario in which multiple transactions insert keys in the same column along with a transaction type column, kindly suggest how to tackle this. The transactions are altogether different from each other, should i make separate FK (or dimension) columns for every transaction type? If I do this than how will I handle this at report level means to show transaction nos. of each transaction in one column.
I have a scenario in which multiple transactions insert keys in the same column along with a transaction type column, kindly suggest how to tackle this. The transactions are altogether different from each other, should i make separate FK (or dimension) columns for every transaction type? If I do this than how will I handle this at report level means to show transaction nos. of each transaction in one column.
farooq78- Posts : 5
Join date : 2012-06-10
Similar topics
» Multiple transaction types, Average Transaction Value, and KPIs
» Multiple local or transaction Currency
» Fact table design: Sales Transaction with multiple Discount rows
» Transaction fact without obvious transaction type field
» How to handle multiple aggregations for multiple KPIs in fact table
» Multiple local or transaction Currency
» Fact table design: Sales Transaction with multiple Discount rows
» Transaction fact without obvious transaction type field
» How to handle multiple aggregations for multiple KPIs in fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum