I have several db's that need to be warehoused that have 'owner' as a conforming dimension. In many cases a fact can have many owners so I was thinking of adding an ownership group dimension with a bridge table to owners.
The real problem I can't quite get my head around is the owners...
The company I work for track refinery capcities around the world and what to
put this data into a data warehouse. At first glance it looks simple enough,
every quarter they take a snapshot of each refineries capacity and that is
the fact table and the dimensions would be owners, location etc...
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.