Skip to Content

Datawarehouse building

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

Add comment
10|10000 characters needed characters exceeded

0 Answers