What is Cardinality
Answers were Sorted based on User's Feedback
Answer / itesh biswal
Simple man
carnality and join are 2 diff things ,u can see in ur
cognos application u will be having 1:n the first part
explains u about the join and the second part tells u the
cardinality ,if in ur 1st part its 1:1 then equi ,if 1:0
then outer if 0:1 then outer if 0:0 its full outer
and the second part tell u the cardinality remember
cardinality never change the query output ,it only identify
the fact and dimension which is very important ,u remember
if u have muti-star schema then it should write two query
depend on two fact ,so pls do it correctly ,
1:n represents fact
1.1 represents dim
Check where is ur measure, put many in that cardinality
Cheers
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / bhaskar reddy
cardnality is the nature of the relationship. 1-1,1-many
relation ships
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / bijayapanda
cardinality is nothing but relation between tables like 1
to 1, 1 to many and many to many.
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / shaik .mahaboob basha
cardinality specifies the nature of relationships between
the query subjects.
it is numeric notation .
the first type says about the type of join ie.,inner or
outer join
and second one says about the number of records
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / p.krishnamohan
Cardinality is defined as howmany times a value of a p.k
can be used as a f.k in the dependent table.
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / bhoom
cardinality is the nature of the relation between two
query items
| Is This Answer Correct ? | 7 Yes | 6 No |
What is the use of 'individual data source' option while using filter in query studio?
1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?
what is Galaxy schema??
When we save a report in report studio with what extn it save?
what is the difference between group span and level span
What do you understand by the term 'aggregate cache'?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
------------------What is Focalpoint?
What is defined as catalog and types of catalogs in Cognos?
how to perform single sign in cognos by using url?
What is the use of report studio?
Explain what is the difference between native sql and cognos sql?