DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers
How do you load the time dimension?
More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Time dimensions are usually loaded by a program that loops through all possible dates that may appear in the data. It is not unusual for 100 years to be represented in a time dimension, with one row per day.
(Continued on next question...)
Other Job Interview Questions