Skip to Content

Join Cardinality in Projected node.

Hello Everyone,

I have a requirement where i want to optimize the join condition, basically i don't want the default join to happen when the fields from the other table is is not queried.

Scenario goes as below:

Left Table: Key1, Key2, Attr1, Measr1

Right Table Key1, Key2, Key3,Attr2, Measr2

Left table and Right Table: BW Analytic View

Right table may or may not contain all the combinations of Keys(key1 and key2).

Now i have a projection which only take Key1, Key2, Attr2 and Measr2 from right table and a Left outer Join with this projection on

LeftTable.Key1 = RightTable.Key1 and

LeftTable.Key2 = RightTable.Key2.

Question:

What should be the cardinality mentioned in the Join and can i make the "Optimize Join Column" check as true in this case.

Thanks for your help!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers