Using below Job Oracle Input-->Iterate ---> Sending Mail to multiple mail ids , now i need to send logs of all the users to whom mail has been sent in single mail .Can you help me how can same be achieved .
something like below
Oracle Input-----Iterate----SEndng Mail---Log----Sendmail(log file with all details as attachment)
Solved! Go to Solution.
JGM i can do that , but then 1 by 1 mail wont' go to user .
Overall first i need to fetch records 1 by 1 and send mail using iterate and then i need to send all those records by mail to users for there information that mail to all these users has been sent .
Could you please try below way?
Since we are using On component ok, it will allow the trowgenerator to push records to target file each time. Please fix 1 record in trowgenerator and select append option in the delimited file.
I have added a tSleep to make sure that we will give some 10 to 20 seconds delay to complete writing the last record to file.
You can use tSendmail to publish the file which will have details of all the records for whom mail was sent.
If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome :-)
Nikhil thats great but can you give me how can i populate field using trowgenerator ,eg. i have 1 value as emailid coming in frm DB and getting passed to sendmail how can i capture same in trowgenerator and then to outputdelimited . Thanks for your response and guidance
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.