Answer Posted / eng-wael
The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the query. Each row in the first table is paired with all the rows in the second table. This happens when there is no relationship defined between the two tables. Both the AUTHOR and STORE tables have ten rows. If we use a Cartesian join in these two tables, we will get back 100 rows.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a fantrap in business objects?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is report template in b.o?
How to open a universe with out using the Designer ??
how to create metric universe ?
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?
what is xcelsius architecture?
Can anybody tell me what are the tuning problems?
Can more than 1 metric be applied on an analytic in business objects?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
When we use aggregate awareness function in designer?
Explain how we drill up week to month?
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...
Explain which versions are used in the bo dashboard work?
What Is The Difference Between Oltp And Olap?