what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / buttguru
The difference is in dimension tables and not the fact
table. Star schema contains denormalized dimension tables
while snowflake schema contains normalized dimension
tables, ie dimension tables are extended in snowflake
schema.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain in detail about type 1?
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 ARE THE META DATA TYPES?WHICH META USING IN BO'S
what is xcelsius architecture?
Did you face any problems while creating reports? Name? Solutions?
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?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
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?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is difference between webi and infoview?
How to restrict password to a user while sending a document in .pdf format
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about a tricky situation for which you found a very simple solution?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,