Answer Posted / vishwamitra

# 1 StarSchema Advantage: Slicing down,performance increase
and
easy to understand the data.


# 2 Star Schema:
Definition: The star schema is the simplest data warehouse
schema. It is called a star schema because the diagram
resembles a star with points radiating from a center.

A single Fact table (center of the star) surrounded by
multiple dimensional tables(the points of the star).
Advantages:

Simplest DW schema
Easy to understand
Easy to Navigate between the tables due to less number of
joins.
Most suitable for Query processing
Disadvantages:
Occupies more space
Highly Denormalized

Snowflake schema:

Definition: A Snowflake schema is a Data warehouse Schema
which consists of a single Fact table and multiple
dimensional tables. These Dimensional tables are
normalized.A variant of the star schema where each
dimension can have its own dimensions.

Advantages:

These tables are easier to maintain
Saves the storage space.
Disadvantages:

Due to large number of joins it is complex to navigate

Starflake schema - Hybrid structure that contains a mixture
of (denormalized) STAR and (normalized) SNOWFLAKE schemas

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1070

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2068

---

What is Online View?

1959

---

Can you define query studio?

960

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2009

---

What is an olap designer?

964

---

can we insert all types of charts in a list report? what r the realtime prompts?

2209

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1913

---

What is set to be cardinality?

1172

---

What do you understand by the cognos?

975

---

What do you understand by the term 'model durability'?

1011

---

How can we create a dynamic column name in cognos?

953

---

What is a Framework manager?

1042

---

------------------What is Inline Query?

2221

---

What is the metric store database?

965

---