You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Look up and Notification if not found?
#1 2011-07-27 10:21:38
- AchyuthB
- Member
- Registered: 2011-06-22
- Posts: 85
Look up and Notification if not found?
Hi,
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.
Thank you
Achyuth B
Offline
#2 2011-07-28 03:13:31
- alevy
- Member
- Registered: 2009-11-20
- Posts: 1477
Re: Look up and Notification if not found?
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.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Look up and Notification if not found?