Answer Posted / sreenivas

Star Schema : Star Schema is a relational database schema
for representing multimensional data. It is the simplest
form of data warehouse schema that contains one or more
dimensions and fact tables. It is called a star schema
because the entity-relationship diagram between dimensions
and fact tables resembles a star where one fact table is
connected to multiple dimensions. The center of the star
schema consists of a large fact table and it points towards
the dimension tables. The advantage of star schema are
slicing down, performance increase and easy understanding of
data.

Snowflake Schema : A snowflake schema is a term that
describes a star schema structure normalized through the use
of outrigger tables. i.e dimension table hierachies are
broken into simpler tables.

In a star schema every dimension will have a primary key.
# In a star schema, a dimension table will not have any
parent table.
# Whereas in a snow flake schema, a dimension table will
have one or more parent tables.
# Hierarchies for the dimensions are stored in the
dimensional table itself in star schema.
# Whereas hierachies are broken into separate tables in snow
flake schema. These hierachies helps to drill down the data
from topmost hierachies to the lowermost hierarchies.

What are the data types present in bo? What happens if we implement view in the designer and report?

1030

---

Can we Save (save as) WEBI Doc as DESKI?

8176

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2427

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4321

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1876

---

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2057

---

Explain what would you consider as your biggest achievement and why?

984

---

what is xcelsius architecture?

4580

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10397

---

Difference between b.o 5.1 and 6.1b?

1256

---

Did you face any problems while creating reports? Name? Solutions?

3692

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1050

---

What three things do you consider to be the most important factors for a manager?

1089

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3082

---

Explain about alerts in bos, under what situation we need to use alerts?

1052

---