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
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How to restrict password to a user while sending a document in .pdf format
Explain which versions are used in the bo dashboard work?
What are the steps to do to use alerts in bo?
Explain about alerts in bos, under what situation we need to use alerts?
Explain when to use local filter and when to use global filter?
What is the difference between condition & filter?
Can Bo generates the Report from the cubical data Explain?
What we need to discuss with designer before starting the universe designing.
How to generate the report from excel sheet?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Difference between zabo and webi?
how many reports have u created ? explain a few.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
how get the grand total in master-detail report?