Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 5946 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 |
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
Where do you set security levels for users in reports?
Column level security in report
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
Use of Text Source Variable in Report Studio?
What are all the types of indexes in Cognos?
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
In a Single page we are having 3 list. While running each has to populated in separate page?
hi,dis is kumari.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 vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
How many fact tables you have in your project?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
Teradata 
