What is Cardinality

Answers were Sorted based on User's Feedback



What is Cardinality..

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

What is Cardinality..

Answer / bhaskar reddy

cardnality is the nature of the relationship. 1-1,1-many
relation ships

Is This Answer Correct ?    13 Yes 1 No

What is Cardinality..

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

What is Cardinality..

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

What is Cardinality..

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

What is Cardinality..

Answer / bhoom

cardinality is the nature of the relation between two
query items

Is This Answer Correct ?    7 Yes 6 No

Post New Answer

More Cognos Interview Questions

What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.

1 Answers  


write a query to display the departments with no employee?

0 Answers   HCL,


suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,


How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

3 Answers  


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,






4. How many dimensions did you use in your reports?

0 Answers   IBM,


hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,


------------- How to identify the Revenue Column in Report?

0 Answers  


What will happen if scheduling a report with a prompt page?

1 Answers   Ness Technologies,


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  


What is the difference between set functions and filter function in dimensional data?

0 Answers  


what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,


Categories