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!
Search results for query: *
- Users: ghowlett2020
- Order by date
-
DateTime as part of PK in FACT Table
Hi, Ok so I know generally its not good idea to have a DateTime column as your PK, however for my situation I believe it makes more sense than having a suggogate key in the Fact Table. The reason are... 1) The data inserted to the fact table is always sequential. I.e. I would never insert...- ghowlett2020
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
