JDBC LookUp - Multiple Records
My Scenario is a File to File and in the mapping need to perform a lookup from database table to extract GUID's for three input fields.At my source structure there are 3 input fileds( Staff_Id, Manager_Id,Partner_Id) and need to extratc their respecive GUID's(GUID,MGUID,PGUID - field names) from the database table and need to to pass it through targte data structure.
And my incoming message is a huge one which contains more than1k records.
I had a few queries -
1.Is a single JDBC Lookup(can we handle to get three different values) will suffice for my purpose - if my source message contains a single record
2.Need to write a UDF using the LOOUP API (database accessor) - could you please throw some info on this to how to handle for three fields and for multiple records.
Please share any ideas/