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
How to generate cubes in cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What are the considerations regarding performance kept in mind while setting up cognos?
What is set to be Cognos configuration?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
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 is the difference between native sql and cognos sql?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Can you define cube?
Can you define set to be cardinality?
What do you mean by drill across?
What are all the advantages of Cognos?
how to explain health care project and which reports we can create in health care doain?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
