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 |
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
What are the different types of connections?Explain?
Can anybody explain me ? without creating the alias can we resolve the fantrap?
can anybody tell me about issues faced while creating reports
What happens in BO when a user logs in to Infoview and a rich client like webi?
I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
HOW TO SPOT A HIERARCHY?
how to do scheduling in desktop intelligence in BO XI R2
Pls Explain about the different between 6.5 & Xi R2
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Can anybody tell me about issues faced while creating universe. thanks in advance