Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15011 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
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.
in general which algorithms for used?
what are relationships?
What are Non-additive facts?
Explain how to generate iqd file from framework manager?
Explain what are the different types of data warehousing?
What is a general purpose scheduling tool?
Which component has onread method and what it is used for?
What are the data marts?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How to create different types of templates?
Explain what is the difference between power center & power mart?
What is a Decision Tree Algorithm?
What is drilling across?
What are the different methods of loading dimension tables?
