WHAT IS CARDINALITY?
Answers were Sorted based on User's Feedback
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 ? | 43 Yes | 1 No |
Answer / poornima
Cardinality defines the numeric relationships between
occurrences of the entities on either end of the
relationship line.
eg:
1)0:0
2)1:0
3)1:1
4)0:M
5)1:M
6)M:M
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / mithru
cardinality is mentioning the relatoin ship between the two
columns participating in a join...eg: if cardinality is 1
to n...for every column value in first table's field there
exists many column values for the field in second table...
for every customer there may exists more than one address
(permanaent and temporary)
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / prasanna.ramesh1
cardinality defines how many instances there for each uniqe
record in the related table.
the sole purpose of cardinality detection is to warn you of
possible loops
| Is This Answer Correct ? | 9 Yes | 1 No |
Cardinality is numerical relationship between two table based on joins. Cardinality describes how many
rows in one table match rows in another table.
Cardinalities having two values because it depend on join.Cardinality values are 0,1,N.
Cardinality relations are 0 to 0
1 to 0
0 to 1
N to 1
i to N
Business objects doesn't support N to N relationship.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / zg
Cardinality is applicable on both entity and attribute levels.
Attribute Level : GENDER[MALE,FEMALE] - cardinality 2
Entity Level: CUSTOMER[HOME ADDRESS, MAILING ADDRESS,
SHIPPING ADDRESS, BILLING ADDRESS] cardinality (1,4)
Customer has 1 to 4 addresses
CUSTOMERS[ORDERS] cardinality (0,N)
Customer may have zero or more orders
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ramana reddy
cardinality defines No of distinct instances that occur in
a column
Ex:There is a column call Gender
Gender
-------
Male
Female
Female
Male
female
Here cordinality of gender is 2
| Is This Answer Correct ? | 6 Yes | 16 No |
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
7.what is data mart?
Explain the difference between union and group?
What is the aggrigate navigation ? can anybody explain me with some practical example?
can BO generate reports with out CUBICAL data to repository?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
What is difference between merged dimension and forced dimension??
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
what are the differences between web intelligence reports and crystal reports ?
What is the user Object ? What is the need of it?
what is stacked chart , Bar chart, Column chart?