Answer Posted / prasanna.ramesh1
chasm trap::
sale
client< rental
chasm trap is a type is a type of join path between 3 tables
when 2 many to one joins converge on single table.
fan trap::
when one table has one -to-many join that "fans out" into
other "one-to-many" join for other table.is fan trap.
a--->b--->
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How would you format some text using css to be verdana and bold?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain what is the difference between slice and dice and cross tab report?
What is the difference between business requirement document and use case document.
Explain when we use aggregate awareness function in designer?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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 the profile and package?
What are the join problems comes appart from loop,chasm & fan Traps
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what task is 98% of the required work of a business analyst?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What are the steps to be taken to schedule the report?
