How can we load the time dimension?
- 1 Answers
- 1283 Views
- I also Faced
- E-Mail Answers
Answer / Abnish Kumar Misra
The time dimension can be loaded by creating a table with attributes such as calendar_year, calendar_month, calendar_day, and calendar_hour. The values for these attributes are typically generated from a calendar table that contains all dates in the data warehouse's history.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Sequence clustering algorithm?
Briefly state different between data ware house & data mart?
what is hybrid schema
Do you view contain data?
Why facts table is useful in representing the data?
What is informatica architecture?
What is edw?
What is data stream and data adaopter. Is it same are different? Explain?
How to eliminate duplicate rows from flat file?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain difference between snow flake and star schema.
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Teradata 
