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?
see
(http://3.hibeauty.sinaapp.com/xx.png)
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
Quote from: bvk.cognoise on 09 Oct 2014 01:30:26 AM
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