Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JamesCarters
- Order by date
-
Conforming dimension feedback
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...- JamesCarters
- Thread
- Replies: 1
- Forum: Data Warehousing/Big Data
-
Slowly changing fact table?
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...- JamesCarters
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
