Hi Gurus,
I made a join between Dimension Model query subject (which has no data as i tested using Test sample option) and Fact Model query subject(which has data as i tested using Test sample option).
I am not getting data ...my question is if dimension has no data and Fact has data ,does a join between them will fetch data?I believe No ,but need your experiences
Kind Regards
Tarun Kumar Das
Quote from: tarunkrdas2013 on 23 Jan 2015 07:06:49 AM
Hi Gurus,
I made a join between Dimension Model query subject (which has no data as i tested using Test sample option) and Fact Model query subject(which has data as i tested using Test sample option).
I am not getting data ...my question is if dimension has no data and Fact has data ,does a join between them will fetch data?I believe No ,but need your experiences
Kind Regards
Tarun Kumar Das
The answer depends upon the cardinality of the relationship between the dimension and fact. If the cardinality at the dimension end of the relationship is "optional" (0..1) then you should get fact rows returned that do not have a corresponding dimension row. If it is mandatory (1..1) you will only get fact rows that have a corresponding dimension row (ie none of them).
MF.