Answer Posted / 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.

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2099

---

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2408

---

Can you define drill down and drill up?

1021

---

how can I test reports in cagnos?

1132

---

New coloums are added in database, then how you know in report level

1545

---

Explain difference between powerplay transformer and power play reports?

938

---

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2102

---

What are the themes in a data warehouse?

1019

---

dumps needed ASAP for - C2020-180 Cognos IBM Certification

2189

---

hi friends pls forward impropmtu interview question

2107

---

how to perform back drill through in cognos 8 what is the use of it

2516

---

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1987

---

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1925

---

----------------------What are the User Securities?

1832

---

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1968

---