Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the deployment requirements used in cognos?
Name the types of gateway?
What are the types of hierarchies?
How create measures and dimensions?
what is hints in cognos and where we use it.
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is meant by junk dimension?
Define query studio?
How do you call a store procedure within a transformation?
What do you mean by Drill down and Drill Up?
What are the themes in a data warehouse?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is the difference between static and dynamic conditions?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What do you understand by the term 'aggregate cache'?
