Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 11814 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bo_fan
Star schema : fact table with dimension tables around.
Snow flake schema: fact table with dimension tables around
and the dimension tables again have sub tables to it.
Example: When we have a scenario like student table and
subject details table (which is a sub table of student table)
There we can go for snow flake schema(going more details ie
normalization)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What we need to discuss with designer before starting the universe designing.
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how many reports have u created ? explain a few.
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
How were the reports scheduled and how to resolve unexecuted documents?
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!!!
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is package in BO
Did you face any problems while creating reports? Name? Solutions?
What is Indexing? how did u implement indexing?
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 in detail about type 2(scd),
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
