Data lookup between 2 sources

edit

Hi,

I am doing a tail on a file. For every record, we need to do a fetch data from the jdbc. But to perform the jdbc lookup for every record wont be the right solution. One way I was thinking was to read the data from the database on "produce event" and join the data. But we do not have join in data collector. any suggestion of how to proceed