There is no query overwrite option in the oracle/SQL server/Redshift lookup. It would be great if you add the below options in the lookup snaps.
- Query overwrite option in the lookup snap.
- As of now when multiple match found , lookup is returning result for all the matching records. If you provide an option to fetch the latest/oldest (First/last) value for the matching records would be very nice.