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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combining Sales fact with Cash Receipts Fact
Yes, the only reason to apportion the discount down to the item was if there was a requirement to calculate profit or loss at the item level. John www.BIonHand.com Online Business Intelligence- BIonHand
- Post #3
- Forum: Data Warehousing/Big Data
-
Making Perfect Copies / Archiving Backup Files
Copying a file does not "corrupt" it. Are you sure this is the term that was used? How exactly are you creating backups? Are you creating backups of a database (using database facilities) or are you doing file-level backups at the operating system level? When backing up a database there is a...- BIonHand
- Post #2
- Forum: Data Warehousing/Big Data
-
Address Dimension /multiple addresses
If you are sure that you only want to record top level company and the division that you are shipping to then the structure you are suggesting should work. You won't be able to track changes to the company structure over time, eg if one company is bought by another, and you also won't be able...- BIonHand
- Post #2
- Forum: Data Warehousing/Big Data
-
Incremental Load
This is the approach I have always taken. The operational area (ODS) contains a complete copy of all data that has ever been loaded into the warehouse and so it does contain copies of all the data that the user accesses. The user data is usually in a separate area, ie a "datamart", and how you...- BIonHand
- Post #8
- Forum: Data Warehousing/Big Data
