Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Tell me about Schemas?

Answers were Sorted based on User's Feedback



Tell me about Schemas?..

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

Tell me about Schemas?..

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

Tell me about Schemas?..

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

Tell me about Schemas?..

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

Post New Answer

More Cognos Interview Questions

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,


Name the types of gateway?

0 Answers  


What is the use of powerplay web viewer in cognos?

0 Answers  


Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  


difference between boxtype and visiable

1 Answers   IBM,


Can you explain the advantage of using shortcuts?

0 Answers  


I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  


What are the different types of OLAP. Which one is Cognos Powercube?

2 Answers   HSBC,


Can you define drill down and drill up?

0 Answers  


I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name

37 Answers   Cisco, L&T,


What is the report studio?

0 Answers  


what are the dimensions that you have in your current project?list them?

0 Answers   IBM,


Categories