Interested to Buy Any Domain ? << Click Here >> for more details...
-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 13805 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / krishnakumari
Star Schema:
Definition: The star schema is the simplest data warehouse
schema. It is called a star schema because the diagram
resembles a star with points radiating from a center.
A single Fact table (center of the star) surrounded by
multiple dimensional tables(the points of the star).
Advantages:
Simplest DW schema
Easy to understand
Easy to Navigate between the tables due to less number of
joins.
Most suitable for Query processing
Disadvantages:
Occupies more space
Highly Denormalized
Snowflake schema:
Definition: A Snowflake schema is a Data warehouse Schema
which consists of a single Fact table and multiple
dimensional tables. These Dimensional tables are
normalized.A variant of the star schema where each
dimension can have its own dimensions.
Advantages:
These tables are easier to maintain
Saves the storage space.
Disadvantages:
Due to large number of joins it is complex to navigate
Starflake schema - Hybrid structure that contains a mixture
of (denormalized) STAR and (normalized) SNOWFLAKE schemas
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What are all the types of gateway used in Cognos?
What is Online View?
-----------------What is Determination Model?
What is the model filter?
Explain what is the main advantage of impromptu over cognos reportnet?
what is hints in cognos and where we use it.
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What are products of cognos?
How security is concerned with Reportnet? Explain its implementing steps.
Can you define cognos impromptu?
What is the difference between regular dimension and derminant?
what is the difference between querystudio in reportnet and cognos8
Explain the difference between native sql and cognos sql?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
