Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

catering multiple transaction ids in one column

Go down

catering multiple transaction ids in one column Empty catering multiple transaction ids in one column

Post  farooq78 Thu Jun 14, 2012 11:14 am

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.

farooq78

Posts : 5
Join date : 2012-06-10

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum