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 |
How to hide/unhide the prompts which are not used by unauthorized users?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
-------------Diff b/w Union and Unionall?
What DB View and Bus View?
where you can save the report net documentation in our local system?
------------------What is Inline Query?
----------------What is meant by DSS?