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!
-
Assigning datetime dimension ID's during ETL
Thanks all.- jakewoods
- Post #5
- Forum: Data Warehousing/Big Data
-
Assigning datetime dimension ID's during ETL
OK, I may need to rethink my table design. Thank you. What do you think about a more general version of the problem though? If you need to measure something at two different levels of detail, do you always need to have two different dimension tables (i.e. date and time) or can you have one...- jakewoods
- Post #3
- Forum: Data Warehousing/Big Data
-
Assigning datetime dimension ID's during ETL
Hello all, I am an experienced DBA but am kind of new to data warehouse thinking, so please excuse me if this question is really basic. I have an OLTP time tracking system I am converting to a DW schema. The system measures time in 15 minute increments, so that is the increment I have used...- jakewoods
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
