Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15353 Views
- I also Faced
- E-Mail Answers
Answer Posted / nethaji
A Star schema consist of fact table surrounded by one or
more dimension tables,which represent a star like
structure.Primary key of dimension tables connect to fact
tables as foreign keys.Data is is denormalized manner.For
better query performance we would go for star schema.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the differences between star and snowflake schemas?
What are the possible data marts in retail sales?
What is meant by metadata in context of a data warehouse and how it is important?
Compare cold fusion with other programming languages?
What is the difference between view filter and report filter?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Suggest a good author for hyperion in data warehousing?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is freehand sql?
Explain meta data?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
How to pivot row data using informatica?
What is drilling across?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain what are slowly changing dimensions?
