Tell me about Schemas?

Question Posted / arkchowdary

4 Answers
10840 Views
I also Faced
E-Mail Answers

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

1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?

0 Answers TCS,

what is the use of lock and unlock

1 Answers

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers Wipro,

What are all the components of Report Studio?

0 Answers

How do we create row level security in cognos8?

3 Answers

what are the applications of the tabular model ????

5 Answers iFlex, iGate,

What is architectue of Cognos 8

4 Answers

explain project, package ,model , modelers.........and differences b/w them?

4 Answers HCL,

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)