" select invoice_number, due_date from invoices " + System.getProperty("where_clause")
WHERE mytable.column = '" + ((String)globalMap("MyValue"))+ "'"
Thank you for your reply.
This is not what I need.
The table content is very huge, millions of records, setting the lookup model to load once is taking lots of time.
It's ok for the query to be executed for every time the job is executed, but if within the same job execution, there is 10 items in the main input, the query is being executed 10 times.
The thing is I have already set a where condition for the query before the tXmlMap component, so that the query returns the appropriate data for these 10 items.
I just have to make the query execute once per job execution.