What is a star schema? Why does one design this way?
- 3 Answers
- 15484 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
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the purpose of Dataware Control?
Explain how to generate iqd file from framework manager?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
