I have two tables TABLE 1 and TABLE 2. Both tables are in oracle database.
I need to join these two tables and left outer join on TABLE 1 and the difference of records need to be sent as an attachment in an Excel sheet in an email.
In this case below two records must be sent in an Excel sheet with headers.
This email should be sent if there is only difference of records in these two tables. If there is no difference of records in these tables then there is no need to send an email.
Please let me know how to achieve this. Please let me now the job flow.
The designed job is scheduled every day.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
This video focuses on different methods of adding metadata to a job in Talend Cloud