Hi All ,
Very good afternoon!
I need help in understanding,the sql generated when in terms of join.
Suppose we have Query Subject 1(QS1) AND QS2
Suppose we have a join like this :
1) QS1(1..N) <--> QS2(1..1)
2) QS2(1..N) <--> QS1(1..1)
what will be sql difference in above two case? in terms in database(sql)
Many thanks in advance!
What is the issue you are trying to solve?
Cardinality is used to identify facts or dimensions and there is a whole section in the Framework Manager guide about it.
Did you try doing both and looking at the SQL to see the differences?
Exploration and reading the documentation is a good way to learn although I'd suggest formal training whenever possible.