Complex predicates in PaPM Cloud vs normal field mapping for predicates

[soundaryacadiga]

Hi Experts,

Can you please let me know which approach is recommended for specifying predicates / join condition in the join in terms of performance as well. Is it via the simple field mapping in the rules or via the complex predicate of the rule to specify this join condition.

Below is the example Normal field mapping :

Complex Predicates :

Thanks,

Soundarya C Adiga

[zhiyitang]

Hi @soundaryacadiga ,

 in your example there is no difference between these two approaches. Both are parsed and translated into the same join condition in the underlying HANA procedure. The complex predicates provides you more powerful possibilities for maintaining complex join conditions which can't be handled by normal field mapping, e.g. LEFT(R0001.C_S_KOSTL, 10) = RIGHT(R0002.C_S_KOSTL, 10).

Best regards,

Zhiyi Tang