Thank you Sir for the reply.
Yes i have looked into them.
The issue i have is that my query statement has multiple join conditions. And also the table is incremental.
So, someone proposed i should convert the query to a database table view, then i can now supply the view name to any of the processors you mentioned above.
Please, do you have a better approach.
Thank you sir.