⟩ Tell us how do you load the time dimension?
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.
Question and Answer:
Home Data Warehouse Developer
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is the difference between OLAP and OLTP?
What are data modeling and data mining? Where it will be used?
What is the difference between aggregate table and materialized view?
"A dimension table is wide but the fact table is deep," Explain the statement in your own words.
What is a data profile?
What is Virtual Data Warehousing?
What is "method/1"?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is the difference between dependent data warehouse and independent data warehouse?
What is the difference between metadata and data dictionary?
