WHAT IS CARDINALITY?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1929


Differences between business objects and web intelligence reports?

801


how to create reports on screech?

2215


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1872


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3278






what is xcelsius architecture?

4274


What Is Snow Flake Schema?

827


What is difference between custom hierarchy and report based hierarchy?

705


When we use aggregate awareness function in designer?

687


how get the grand total in master-detail report?

1956


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2101


When to use local filter and when to use global filter?

741


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1899


Explain is there any other repository domains rather than universe, security, document?

726


Explain how to execute the plsql procedure from the report by clicking with mouse?

753