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 to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
What is self join
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....
How to hide objects or columns?
How to get top 5 rows of a selected column?
Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier
how can u find the granularity in fact table
when to go for alias and when to go for contexts
When we use aggregate awareness function in designer?
limitaions of cross tab ?
Differences between business objects and web intelligence reports?
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?