1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

when we go for snow flake schema rather than star schema ?

Question Posted / babu

Answer Posted / babu

whether the schema contains in normalized form and data should be redundancy is required then we go for snow flake schema and the dimension table should split into another child table in this situation we go for snowflake schema rather than star schema.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain when to use local filter and when to use global filter?

592

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

547

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1823

How to schedule the report in b.o?

553

Explain how to execute the plsql procedure from the report by clicking with mouse?

592




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

2595

What are the steps to do to use alerts in bo?

625

Explain about a tricky situation for which you found a very simple solution?

532

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1608

What is the difference between the public object&schema object?

564

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

1395

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

1964

any difficulitis have you phase while creating bo reports and how did u solve it

2984

What is Indexing? how did u implement indexing?

1806

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

569