Could you please help on conversion of PLSQL code into talend.
I have attached the code.
I hope you gone though attached code.
I have source is excel file and Oracle table.
Src_excel -- daily load
Orc_table -- first day
Orc_table -- second day
I need to compare both file and table daily wise.
first day comparison result based on ID set flag "matched" and "ummatched". we are storing differencent table based on match and unmatch records.
second day comparison result based on ID set flag "matched" and "ummatched"
2, 20/07/2017, matched
i need compare previous one day date with file table on daily wise.
Reason: in oracle table we are getting few records next day.
1) Need to compare oracle table records into current file records with previous unmatched records.
2) comparison of previous day is one not more than.
3) if not matched previous day also transfer all records to um natch table.
Please let me know if need more information.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.