what is the difference b/w star and snowflack schema in
dataware house?
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 in detail about type 1?
What is the difference between user and versatile user?
Explain in detail about type 2(scd),
Explain what three things do you consider to be the most important factors for a manager?
What task is 98% of the required work of a business analyst?
how get the grand total in master-detail report?
What is the difference between slice and dice and cross tab report?
Explain about a time when you discovered a more efficient way to do a work task?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain what sort of existing documents should business analysts refer to when starting on a new project?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What are all difference between business objects 6.5 and xi r2?
can anybody tell me about complicated object you have created
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is difference between custom hierarchy and report based hierarchy?