What snowflake and Starschema?
- 2 Answers
- 5370 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhaskar.nagi
Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.
Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srini madhala
Star Schema:In Star shema we have fact table sorrounded by
diemension table.Since the shape looks as a star its called
as star schema
Snow Flake Schema:
in Snow flake schema we have fact table sorrounded by
diemension table and the diemensional table have their child
diemensions.Its denormalized
| Is This Answer Correct ? | 3 Yes | 2 No |
What are the advantages and disadvantages of using Transformer cube?
tell me two or three issues from client side and how to solve those issues?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What is model filter?
why we r using report studio in webbased only and fm windows based only
How can we create a dynamic column name in cognos?
What is a Cube?
how many types of formats you can run a report using cognos?
What is snapshot ?
What are differences between Reporter report and Explorer report?
wt is the differnce between Block & conditional block ?
How to hide/unhide the prompts which are not used by unauthorized users?
Teradata 
