What snowflake and Starschema?
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 you mean by drill across and what is the difference between drill through, drill across?
Which one is better among Value and select & search prompts,in terms of performance?
is cognos 7 is better than cognos 8
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
Can you define query studio?
What is meant by Tabular SQL in Cognos Report net
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
7. What is performance tuning?
how to convert crosstab into list?
what is mean by cognos powerhouse?