We have a requirement for JDBC lookup.
At JDBC side we have a stored procedure which taking a request and fetching data from 4 different tables.
Now We want to call this SP in our JDBC lookup at PI mapping.
But I am not sure how to call SP within the graphical lookup tab.
Also we have doubt on which table structure need to be imported in PI.
Need to import all 4 table or we need to create a view at JDBC side and import the structure?
Is there any way we can call SP name at JDBC receiver channel?.