when we go for snow flake schema rather than star schema ?
Answer Posted / divya
Snow flake schema is used when there are hierarchies,where
as star schema is used when there is only one level and no
hierachies
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is Indexing? how did u implement indexing?
(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 when we use aggregate awareness function in designer?
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
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what is the difference between business requirement document and use case document.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Can we configure two instances of CMS pointing to two different CMS system databases?
What is the dense rank?
how many reports have u created ? explain a few.
Explain how to execute the plsql procedure from the report by clicking with mouse?
what is xcelsius architecture?