Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 6078 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 |
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
--------------Explain Table of contents?
What are the two types of framework manager?
1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Can i apply drill through on chart in report studio?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is Local Cache and how does it help in performance tuning
can we join 2 different queries? One has 10 columns and other has 5+ columns?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Teradata 
