Data Model Validation Result

Summary

SQL query contains non-equi joins

Content

Hi Guys,

I am in 18C and I am getting the following warning message in Data Model:

WARNING

Dataset:LOV_Emp_Name

SQL query contains non-equi joins. This could results in performance issues due to intermediate row spawning. Replace non-equi joins with equi join or outer join.

Here is the piece of the code which BI is complaining:  

AND TRUNC (SYSDATE) BETWEEN PAPF.effective_start_date AND PAPF.effective_end_date

AND TRUNC (SYSDATE) BETWEEN PPNF.effective_start_date AND PPNF.effective_end_date

AND TRUNC (SYSDATE) BETWEEN PAAM.effective_start_date AND