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 |
What is domain? How many are there in a basic setup? What are they?
What is the difference between absolute and relative div positioning?
What is the difference between Boxir2 and Boxir3?
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)?
What is batch processing in Business Objects?
What is scope of analysis ?
limitaions of cross tab ?
How will solve a loop caused by lookup table without using alias?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
what is the difference b/w star and snowflack schema in dataware house?
What is Indexing? how did u implement indexing?
What are the data types present in bo? What happens if we implement view in the designer and report?