Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS CARDINALITIES OF JOIN?
- 3 Answers
- 17963 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Cardinality is a property of a join that describes how many
rows in one table match rows in another table. Cardinality
is expressed as the minimum and maximum number of rows in a
column at one end of a join, that have matching rows in the
column at the other end of the join. The minimum and the
maximum number of row matches can be equal to 0, 1, or N.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / nareshkumar
Cardinality is a property of a join that describes how many
rows in one table match rows in another table.
Cardinality is expressed as the minimum and maximum number
of rows in a column at one end of a join, that have
matching rows in the column at the other end of the join.
The minimum and the maximum number of row matches can be
equal to 0, 1, or N.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / devi
join between one to one ,one to many,many to one or many to
many
| Is This Answer Correct ? | 2 Yes | 2 No |
how to optimize the query perfomance in b.o?
What is aggregate table and aggregate fact table ... Any examples of both?
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)?
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
What is the difference between business requirement document and use case document.
What is the Difference b/w Server based Ranking and normal Ranking?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
What is the use of Surrogate key in BO?
How to schedule the report in b.o?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
Teradata 
