left joins

[everlearner]

Hi gurus,

please can any one explain how to create a left join between 2 tables in framework manager. i have little confusion at operator, cardinality in relationship definition window. please any one make me clear.

thanks in adv

[CoolP]

Hi,


The best way to check the join conditions is to select both the query subjects after creating the join and rightclick them to test it. Then you will get options to look at the query created by FM. If you wanted something else, you can come, change the cardinality and then check.




Thanks
CP

[Cognos_World]

The cardinality will look something like
1...1 on the left side and 0..n on the right side (in the drop down).
This will create a left outer join.

Also verify the Relationship Impact description.

The way to understand the relationship impact without the description is to see/read the cardinality from the opposite table for the 1st one and vice versa.

If 0..n is on the right hand side in the drop down, it reads outer join for the left side of the relationship.
Or, to put it in another way, we define the cardinality in the drop down for the each row of the other table.

Hope this helps!