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
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how to create metric universe ?
What is difference between custom hierarchy and report based hierarchy?
How to execute the plsql procedure from the report by clicking with mouse?
Give some information on report bursting?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Can Bo generates the Report from the cubical data Explain?
in sap bi we have wad, then why we go for sap bo
How to generate the report from excel sheet?
Explain in detail about type 1?
When to use local filter and when to use global filter?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain what are the measure objects?
Can anybody tell me what are the tuning problems?
Explain about alerts in bos, under what situation we need to use alerts?