Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Could you please help on conversion of PLSQL code into talend.
I have attached the code.
Thanks
Shridhar
Hi,
I hope you gone though attached code.
I have source is excel file and Oracle table.
Src_excel -- daily load
ID, TXN_DATE
1, 20/07/2017
2, 20/07/2017
3, 20/07/2017
Orc_table -- first day
ID,TXN_DATE
1, 20/07/2017
Orc_table -- second day
ID,TXN_DATE
2, 21/07/2017
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.
Stg_matched table.
ID, TXN_DATE,flag
1, 20/07/2017,matched
stg_unmacthed table.
3, 20/07/2017,unmatched
second day comparison result based on ID set flag "matched" and "ummatched"
Stg_matched table.
ID, TXN_DATE,flag
1, 20/07/2017,matched
2, 20/07/2017, matched
stg_unmacthed table.
3, 20/07/2017,unmatched
i need compare previous one day date with file table on daily wise.
Reason: in oracle table we are getting few records next day.
Constraints:
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.
Hi,
Thanks for your input.
Could you please elaborate how to catch the unmatched record to compare next day.
Thanks
Shridhar