Hi all,
i have two tables,
lets suppose A,B.
in table A the column has values like 110,111,112..etc
in Tbale B the column has values like 110,110,110,111,112..etc
am getting confusion at cardinality when creating relationship in framework manager.
i have to create left outer join for this.
can any one tell me the which cardinality i should take for table A and table B?
thanks in adv
Cardinality is about 2 things:
1. Deciding whether a normal join suffices or an outer join is required
2. Deciding if you want subjects to behave like dimension vs fact
When Table A is joined to Table B and you need data returned from table A regardless whether key value exists in table B then you set cardinality as:
1:1 <--> 1:0 or 1:n <--> 1.0
When you set the cardinality Cognos explains the consequence directly below the cardinality setting
edit:
Please keep your posts on the same subject together..
thanks blom for the explanation.
another doubt, i tried to get right outer join. i tried in all possible ways. but i didt get. for suppose to get right outer join what shud i so?
Put the 'n' at the other side of the relationship from your original left outer join. A Right Outer Join simply has the "many" cardinality on the opposite side to a left outer join.
Regards,
MF.