Need help on how to find the no of rows inserted/updated/deleted.
Hi Team,
I am using fileInputDelimeted -> tmap -> tOracleOutput, can any one please let me know how to check no of rows inserted/updated/deleted in this way.
Thanks & Regards,
Rajendra Lella.
Hi Sabrina, Thanks for your quick reply, Please could you also help me on below query, I have 18 tfileInputDelimeted files to be scheduled and how can I consolidate the status of these jobs in a single mail? Thanks & Regards, Rajendra Lella.
Hi Sabrina, My query is, instead of scheduling 18 jobs individually, How can I schedule 18 tfileInputDelimeted in one job and once all these jobs are success of failure the e-mail should be sent. How is it possible? could you help me on these lines.. thanks & regards, rajendra
Hi,
The 18 tfileInputDelimeted files are same column structure? Do you want to extract data from 18 delimited files into one output? Could you please give us more description about current situation?
Best regards
Sabrina
Hi Rajendra,
Better way of doing this is
- Create a subjob for each file
- Create one log table to write the audit information about each file
- Insert all the data for execution of each job in the database table using variables
- Create one master job which calls all these subjobs
- Create one more job to fetch data from log table, arrange it in html table, assign its value to context variable
- Use this value in tsendmail component to send mail with table contents into it..
I hope you got the point
Thanks
Vaibhav
Hi, The 18 tfileInputDelimeted files are same column structure? Do you want to extract data from 18 delimited files into one output? Could you please give us more description about current situation? Best regards Sabrina
Hi Sabrina,
the 18 tfileInputDelimeted files need to be transferred to different tables in a database,
ex:
tinputfileA \ / tableA
tinputfileB _ tmap -> tableB
tinputfileC / \ tableC
once the job is done I need the consolidated e-mail to be sent.
Hi,
From your description, you can use onSubjobOk connector to trigger tsendmail .
The workflow should be:
tinputfileA \ / tableA
tinputfileB _ tmap -> tableB
tinputfileC / \ tableC
| |
OnSubjobOk OnSubjoberror
/ \
tsendmail tsendmail
Here is a related forum:
https://community.talend.com/t5/Design-and-Development/Message-in-Talend-Stats-quot-success-quot-eve... Hope it will be helpful for you. Or do you want to send an email with number of inserted/updated/deleted rows?
Best regards
Sabrina
