Answer Posted / prasanna.ramesh1
when there is one-to-many jointo a table that "fans out"
into another "one- to-many" join to another table.this
problem is called fan trap.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is top business?
Explain about a tricky situation for which you found a very simple solution?
Explain what are the measure objects?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What is a fantrap in business objects?
Explain what are the steps to be taken to schedule the report?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What Is The Difference Between Oltp And Olap?
Did you face any problems while creating reports? Name? Solutions?
Explain in detail about type 2(scd),
What is the difference between business requirement document and use case document.
