when we go for snow flake schema rather than star schema ?
Answer Posted / bo_fan
Star schema : fact table with dimension tables around.
Snow flake schema: fact table with dimension tables around
and the dimension tables again have sub tables to it.
Example: When we have a scenario like student table and
subject details table (which is a sub table of student table)
There we can go for snow flake schema(going more details ie
normalization)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
8. How much supervision have you typically received in your previous job?
How to schedule the report in b.o?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Can Bo generates the Report from the cubical data Explain?
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
what is universe null
How can you first report in Business Objects by using broadcast agent?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is the difference between absolute and relative div positioning?
Difference between b.o 5.1 and 6.1b?
What are the steps to do to use alerts in bo?
What is the difference between the public object&schema object?
how to create metric universe ?
Explain about a task that really tested your analytical abilities?
Explain how to schedule the report in b.o?