Skip to Content
0
Jan 29, 2016 at 06:20 AM

Data based on optional conditions

20 Views

Hi,

A requirement is like this:

2 tables - employee and condition. In condition table, there can be 0 or n number of records.

Based on condition table, data from employee has to be fetched depending on attribute operator and value.

An attribute may occur more than once also (example EID).

With dynamic SQL, it is easy to evaluate but it effects the performance as my table size is very huge.

How to achieve this efficiently?

Copying SAP HANA Developer Center

Regards

Raj

Attachments

tABLES.jpg (71.0 kB)