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 Metrics designer?
What is the size of the cube?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is defined as Query studio?
faq's on cognos
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is called cognos reporting tool?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is the metric store database?
What is meant by junk dimension?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what is a prompt value in report studio and variables ?
