what is the difference b/w star and snowflack schema in
dataware house?
- 8 Answers
- 9646 Views
- I also Faced
- E-Mail Answers
Answer Posted / shekar
Star schema: one fact table is sorrounded by de-normalised
dimension table. In star schema we dont have any extended
dimension tables.
Snow flake schema: one fact table is sorrounded by
ormalised dimension table.In Snowflake schema we can have
extended dimension tables.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
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
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are the join problems comes appart from loop,chasm & fan Traps
can anybody tell me about complicated object you have created
Explain what are the steps to be taken to schedule the report?
How to open a universe with out using the Designer ??
What three things do you consider to be the most important factors for a manager?
What is the difference between slice and dice and cross tab report?
Explain 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)?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
how get the grand total in master-detail report?
8. How much supervision have you typically received in your previous job?
What is a bo repository?
how many reports have u created ? explain a few.
