when we go for snow flake schema rather than star schema ?
- 5 Answers
- 10980 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / murali
snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.
Draw-back: Slow performance for executing the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is package in BO
Explain what is the difference between slice and dice and cross tab report?
How to restrict password to a user while sending a document in .pdf format
U r project in which stage in implementation?
Explain how to schedule the report in b.o?
Explain about a tricky situation for which you found a very simple solution?
What task is 98% of the required work of a business analyst?
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 the difference between user and versatile user?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
8. How much supervision have you typically received in your previous job?
What is the dense rank?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain is there any default username & pwd for bo designer & supervisor?
