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 strongm 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: brihaspati
- Order by date
-
Need help modeling for back in time changes in dimensional model
With type 2 dimensions, I will have to go and update dim keys in fact tables, which will be little messy. For ex., I have product dimension with fields say prdid, prdname, effectivefromdate and effectivetodate. I have salesfact where I have prdid, saledate and salesvolume. product dim 1...- brihaspati
- Post #4
- Forum: Data Warehousing/Big Data
-
Need help modeling for back in time changes in dimensional model
I am designing a data model where data ( both dimension and fact) will have back in time changes or retroactive changes. Please suggest me pointers on how to handle it.- brihaspati
- Thread
- Replies: 8
- Forum: Data Warehousing/Big Data
