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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Large table Update problems
I'm on SQL Server 2000 and I'm about to update two columns on a large (tall and wide) table in my DW. The tables look like this. DW_INVOICE(TRANS_ID,INVOICE_DATE,AMOUNT,etc) 100 milj rows, 15 GB data DW_INVOICE_CARD(TRANS_ID,DISCOUNT_PERC,DISCOUNT_AMOUNT,etc) 97 milj rows, 23 GB data The...- lbe
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
Time/Date Dimension, Surrogate Key or not
Hi all, I'm about to design a Time/Date Dimension (on Day level) for a customer and I'm convinced of doing it the Kimball way is as close as perfect you could get (ie creating a spreadsheet as source). Roughly. I'm not convinced that the use of a surrogate key is the best choice. In Kimball's...- lbe
- Thread
- Replies: 13
- Forum: Data Warehousing/Big Data
