Answer Posted / chinna
A Cartesian product tends to generat a large number of
rows, and the result is rarely useful.You should always
include a valid join condition in a where clause,unless you
have a specific need to combine all rows from all tables.
| Is This Answer Correct ? | 12 Yes | 10 No |
Post New Answer View All Answers
Explain is there any default username & pwd for bo designer & supervisor?
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 difference between condition & filter?
8. How much supervision have you typically received in your previous job?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
can anybody tell me about complicated object you have created
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference in creating filters in designer and business objects?
How can you first report in Business Objects by using broadcast agent?
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 ?
Did you face any problems while creating reports? Name? Solutions?
Explain the difference between union and group?
What is package in BO
How to create Index to the table in the universe designer and how it improves the Query performence
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)?