Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 5989 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 have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
WHAT ARE THE DISTNICT VARIABLES?
In how many ways we can apply the security to a cube in Transformer? Explain?
how to create measures and dimensions?
Can you define cognos decision stream?
what is the difference between rollup aggregation and aggregation ?
How can we improve performance in report studio level?
where we use page break and page set. with example?
Hi Experts, Can a single package be shared by multiple users?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
Is it possible to apply access manager user rights in impromptu?
Teradata 
