Tell me about Schemas?
Answers were Sorted based on User's Feedback
Answer / arkchowdary
Hi,
There are 4 types of schemas are there.
Star Schema,
Snowflake Schema,
Starflake Schema,
Galaxy Schema.
Satar Schema---------------- In a starshema a central
facttable connects a number of individual dimension tables
this is called as a starschema.
------------ It contains lessjoins so perfomance will be
increase.
------------ Starschema contains denormalized data.
Snowflake Schema------------- One dimension table split into
more than one dimension this is known as snowflakeschema.
---------------- Snowflake contains normalized data. There
are more joins in snowflake schema. so the performance is
degrade.
Galaxy Schema-------- Galaxyschema is known as a
Factconstollation schema. It requires number of facttables
and Dimension tables this is known as a Galaxyschema.
I hope it willbe helpful.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / krishna
Schema is nothing but logical structure of data.
there of four types
1.star schema
2.snowflake schema
3.star flake schema
4.galaxy schema
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swan
There are 2 types of schemas
1)star schema
2)snowflake schema
star schema is amiddle of the fact table it connects to the
no.of individual dimention tables.It containd de-normalized
data
snowflake schema is is a set of tables comprised of a
single, central fact table surrounded by normalized
dimension hierarchies. Each dimension level is represented
in a table. Snowflake schema implements dimensional data
structures with fully normalized dimensions. Star schemas
are an alternative to snowflake schema
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / satya
There are two types of schemas are there
1) Star schema
2) snow flake schema
Is This Answer Correct ? | 4 Yes | 6 No |
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
Column level security in report
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
how can you get the errors in job? when loops are araised we get error?
what is an associated query?
What is a Datastore in Cognos?
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
What is drill down and slicing and dicing whats the difference between them?
What is stitched Query?
Can anyone tell me the step by step process how to connect cognos to oracle?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
What DB View and Bus View?