Join operator in Cognos Report Studio

[yogeswari]

Hi All,

Could anyone please share your inputs for Join operator and its relationships in Cognos Report Studio.
I am also attaching the screenshots for which i am exactly looking for.

Please provide your inputs as it would be able to understand better since i am fresher.

Thanks,
yogeswari.

[TheCognosDave]

Hey Yoge, here's my 2 cents...

Join is when you're looking to intersect data-sets, and correlate the results from one object/SQL to another.  Although Cognos supports this on the application server, it's invariably slower than letting the database join the data.  For performance reasons, in most cases this type of "rowset" logic is best left to the database.

Good Luck !  ;)

[yogeswari]

Hi,

Thanks for your response.  i am unable to get back to this due to sick for a week:(

I am searching for the explainations for the attachment.  Please explain as am not clear of what purpose this operator is?

Thanks,
yogeswari.

[BigChris]

Ok - if this sounds like I'm teaching you how to suck eggs that's not my intention:

Query 1 will contain all the records that are in both B and C. Looking at the cardinality of your join you could have more that one record for the Bundle ID in C, so your query may bring return multiple records. If there's a record, for example, that exists in B but not in C, it won't be shown in Query 1.

Hope that helps.

C

[yogeswari]

ok..thank you...