You are not logged in.
I am using tMap for doing lookup.
Process one input file, before inserting the records to the database table; do a lookup on a another database table for each of the records in the input File.
If the lookup value is available (if there is a match between the value in the feed file and lookup table) for a record then fine and good.
Otherwise if there is no matching record, then i need to send a notification (say email) saying that "this value do not have a lookup data".
Can you please tell me how do I achieve this.
Presuming that you are using an inner-join in tMap, have a second output flow, selecting the inner-join reject option. Send that flow to a tSendMail component, which can use the row values as part of the message.