Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w star and snowflack schema in
dataware house?
- 8 Answers
- 12267 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
Explain when we use aggregate awareness function in designer?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How were the reports scheduled and how to resolve unexecuted documents?
Give some information on report bursting?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between slice and dice and cross tab report?
What is top business?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference between business requirement document and use case document.
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)?
Explain how many universes can be created in a project?
Explain what are the measure objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
any difficulitis have you phase while creating bo reports and how did u solve it
