please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
Answer Posted / padmalatha0923
star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about a task that really tested your analytical abilities?
What three things do you consider to be the most important factors for a manager?
what is universe null
When to use local filter and when to use global filter?
is it possible to export the webi reports to crystal reports?with out using businessview?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
what are the tables used in health care domain project and columns used in report?
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...
Explain when to use local filter and when to use global filter?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain is data mart?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
any difficulitis have you phase while creating bo reports and how did u solve it
what is xcelsius architecture?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?