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 |
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
Shall we connect to the oltp systems directly .,
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE
How to Implement the the Built-in Strategy Script in BO Designer?
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
Difference between drill by and drill across with example?
What is difference between merged dimension and forced dimension??
what are cascading prompts explain with steps