Skip to Content
0

Datawarehouse building

Feb 28, 2017 at 01:23 PM

23

avatar image

I am trying to create a datawarehouse.. where i need experts advice..

i have OLTP database where there is patient, waitinglist table attached to appointment with one-to-many relationship.. which means that 1 patient can have multiple waitinglist and 1 waitinglist can have multiple appointments...

i have created Patient dimension table.. one easy way that i should create waitinglist table as dimension and appointment table as fact table..

I want to ask is it possible to combine waitinglist and appointment table in one fact table..

Please help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers