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 StarShema?
tell me the creation of Snapshots?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
what is the difference between count and running-count functions?
Which studio is used to create reports?
fiscal year means what???
9. What was the most complex type of report you dealt with?
How you create IQD In ReportNet FrameWork?
What do you mean by drill across?
Define metrics studio?
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
What is Clipboard? How to import XML file into Clipboard?