Data Warehouse Developer Question:
Tell us how do you load the time dimension?
Answer:
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.
| Previous Question | Next Question |
| Explain me the functions of data warehouse tools and utilities? | Do you know what is load manager? |