What is a star schema? Why does one design this way?
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
Why is dimensional normalization not required?
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 is cubes?
What is the goal of optimizer?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is Active Datawarehousing?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Which are the olap tools available that are supported by oracle?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
How to generate iqd file from framework manager?
What are vaious etl tools in the market?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Explain what are the mapping paramaters and maping variables?
What is bi?