Answer Posted / kishore pothuri
A fan trap is a type of join path between three tables when
a “one-to-many”
join links a table which is in turn linked by another “one-
to-many” join. The
fanning out effect of “one-to-many” joins can cause
incorrect results to be
returned when a query includes objects based on both tables.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is thumbnail?
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?
Explain about alerts in bos, under what situation we need to use alerts?
Explain what would you consider as your biggest achievement and why?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain is there any default username & pwd for bo designer & supervisor?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
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?
Explain what task is 98% of the required work of a business analyst?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What Is The Difference Between Oltp And Olap?
8. How much supervision have you typically received in your previous job?
What is the difference between slice and dice and cross tab report?
Explain the difference between detect alias and detect context?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.