Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about Schemas?
- 4 Answers
- 10860 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 can you get the errors in job? when loops are araised we get error?
Can you define a catalog and types of catalogs in cognos?
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
How will you migrate your reports to QA environment?
Are you aware of any limitations in Cognos?
what is the automation tool used for data warehouse testing???
3 Answers Covansys, IBM, Wipro,
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
how can I test reports in cagnos?
Define dimensions?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
what is the role of cognos comsultant?what actually it means?pls reply
What is defined as catalog and types of catalogs in Cognos?
Teradata 
