Hi Anand,
I think the situation that you are in demands you to firstly meet the customer expectation and give him the luxary of accessing provider_no from the fact table.
Now to satisfy your DWH instincts you should build the Provider dimension table and have the Provider Key added to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.