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.

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

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

Answer / satya

There are two types of schemas are there
1) Star schema
2) snow flake schema

If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,

0 Answers  

---

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

---

There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

1 Answers   CTS, IBM,

---

what are versions of cognos from starting release to latest in the market?

7 Answers   DELL, IBM,

---

-------------What is a Conformed Dimension?

3 Answers   Bank Of America,

---

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

0 Answers   IBM,

---

What are differences between Reporter report and Explorer report?

2 Answers  

---

hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

1 Answers   HCL,

---

what are the errors faced while bursting the reports and how to solve those errors?

0 Answers   EDS,

---

hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  

---

what is a prompt value in report studio and variables ?

0 Answers  

---

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers  

---