Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15349 Views
- I also Faced
- E-Mail Answers
Answer Posted / pratap gangula
STAR Schema is a design that has a collection of one fact table and many dimension tables. Fact tables have the foreign keys to all the dimension tables and also keeps the additive measures for analysis. Dimension tables have the information needed to describe the measures in the fact. Basically dimensions are entities with all the attributes in a denormalized form.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
in general which algorithms for used?
Explain the difference between dw and bi?
What are the data types present in bo?
What is drilling across?
Explain difference between view and materialized view?
What is "method/1"?
Explain is fact table?
What is hybrid slowly changing dimension?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are diagrams?
Explain what is real time data-warehousing?
Can you state some of the innovations throughout history?
Explain how are the dimension tables designed?
