Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 6085 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 is the information present in the cognos configuration file?
How to apply securities for reports in cognos connection?
what is the role of cognos comsultant?what actually it means?pls reply
What are the different uses of a repository manager?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
how you migrate reports to cognos 8 from previous versions?
What are the steps involved in migrating CRN enviroment to Cognos 8?
3 Answers BMW, Goyal Group, Mersan,
what is symmetric key?where do u use this?
What is the use of powerplay web viewer in cognos?
What is the difference between a data mart and a data warehouse?
advantages of cascade prompt ???
what is model and how to create model and how to test model?
Teradata 
