Data Warehouse Developer Interview Question:

Tell us how do you load the time dimension?

Submitted by: Muhammad

Time dimensions are usually loaded by a program that loops through all possible dates appearing in the data. It is not unusual for 100 years to be represented in a time dimension, with one row per day.
Submitted by: Muhammad