Joins in RS?

[bvk.cognoise]

can somebody help in on this I have two  query's i am going to join these two query's in report studio
now if give flowing carnality between these two query's based on a dimension called "login id".Please tell me what join are they

DimQ1LoginID-Dimq2LoginID
1:n   0:1


DimQ1LoginID-Dimq2LoginID
1:0   1:n

what joins are they please explain?

[linbai]

see

[bvk.cognoise]

Hi linbai,

Thanks for your reply but i could not able to understand it.

could you please tell me what kind of relation ships are

DimQ1LoginID-Dimq2LoginID?
1:n   0:1


DimQ1LoginID-Dimq2LoginID?
1:0   1:n


DimQ1LoginID-Dimq2LoginID?

1:1   1:n


DimQ1LoginID-Dimq2LoginID?

1:n   1:1

all are query subjects joins please explain what are th join types Eg: Inner,left,right,full.

her i am getting some confusion every time.

Regards
bvk

[Lynn]

Hi linbai,

Thanks for your reply but i could not able to understand it.

could you please tell me what kind of relation ships are

DimQ1LoginID-Dimq2LoginID?
1:n   0:1


DimQ1LoginID-Dimq2LoginID?
1:0   1:n


DimQ1LoginID-Dimq2LoginID?

1:1   1:n


DimQ1LoginID-Dimq2LoginID?

1:n   1:1

all are query subjects joins please explain what are th join types Eg: Inner,left,right,full.

her i am getting some confusion every time.

Regards
bvk

I think linbai is illustrating that you can simply look at the relationship impact in the join window to understand what each one means. Is there a specific problem you are trying to solve? This document explains the cardinality notation and the relationship impact window to help you understand.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_fm.8.4.0.doc/ug_fm_id3601cardinality.html%23cardinality