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
Can Bo generates the Report from the cubical data Explain?
What is the functional & architectural differences between business objects and web intelligence reports?
Give some information on report bursting?
what is xcelsius architecture?
How to open a universe with out using the Designer ??
Did you face any problems while creating reports? Name? Solutions?
what will be the contents for a functional requirements specifications
is it possible to export the webi reports to crystal reports?with out using businessview?
How to schedule the report in b.o?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What are the data types present in bo? What happens if we implement view in the designer and report?
What are the join problems comes appart from loop,chasm & fan Traps
What is thumbnail?