Explain how are the dimension tables designed?
- 0 Answers
- 740 Views
- I also Faced
- E-Mail Answers
How can we load the time dimension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What are session timeout and application timeout? Where we have to do this process?
What is a star schema? Why does one design this way?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is surrogate key? Where we use it explain with example?
Explain multivalued dependency?
what is difference between drill & scope of analysis?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain the structure of cold fusion?
What are the design methods of data warehousing?
What is multi-dimensional analysis?
Teradata 
