sql generated when in terms of join

[nsaxena]

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!

[Lynn]

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.