Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about Schemas?
- 4 Answers
- 11005 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 |
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
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 session parameters? what is use?
How to perform single signon in Cognos by using URL?
Mention the difference between ‘macros’ and ‘prompt’?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
Is it possible to join multiple Databases in a Catalog?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
What is the enterprise class platform architecture of cognos 8?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
What is a Transformer?
Teradata 
