Tell me about Schemas?
- 4 Answers
- 11128 Views
- I also Faced
- E-Mail Answers
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 |
how many types of formats you can run a report using cognos?
what are the special features in cognos reportnet?
can we join 2 different queries? One has 10 columns and other has 5+ columns?
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
What is Outerjoin?
In framework Manager, what is a stitch query and is it good or bad?
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
What is architectue of Cognos 8
What is main advantage datawarehousing over oracle?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
in which scenario we go for views in cognos or oracle?
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
Teradata 
