COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: thedon_1 on 07 Feb 2012 11:02:11 AM

Title: What does the operator do when selecting cardinality on a join?
Post by: thedon_1 on 07 Feb 2012 11:02:11 AM
As the topic says, when setting cardinality, what does changing the operator do?

I awlays have it on = but am currious to know what the other operators did and when they are used.

Thanks
Title: Re: What does the operator do when selecting cardinality on a join?
Post by: blom0344 on 07 Feb 2012 02:16:36 PM
Perform a search on theta joins!!

Basically this is a vast subject where you will learn about cartesian products (cross joins), triangular joins (  < ,  > ), non-equi joins (<>)  and  'between' joins. They can all have their specific use, but since this is a Cognos forum I'll try and keep quiet   ;)

In regular models you will not use anything else than =  , mind you!!