topic Re: Convert PLSQL code into talend in Talend Studio

Convert PLSQL code into talend

Anonymous — Fri, 21 Jul 2017 04:46:34 GMT

Hi Team,

Could you please help on conversion of PLSQL code into talend.

I have attached the code.

Thanks

Shridhar

Re: Convert PLSQL code into talend

TRF — Fri, 21 Jul 2017 05:39:20 GMT

Complete your question with sample data. What's the usecase? What's your input? What's the expected result?
Even if the code is not complicated, it should be better for an appropriate answer as you cannot expect a simple translation from PL/SQL code to Talend job.

Re: Convert PLSQL code into talend

Anonymous — Fri, 21 Jul 2017 06:12:11 GMT

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.

Re: Convert PLSQL code into talend

TRF — Fri, 21 Jul 2017 07:48:58 GMT

Using tMap join (inner) both Excel file (main row) and Orc_table (lookup).
Insert matching rows into Stg_matched table and catched rows into stg_unmacthed (so you need 2 output flows from the tMap).
Having a primary keyon these tables avoid duplicates, else truncate them when job starts.

Re: Convert PLSQL code into talend

Anonymous — Sun, 23 Jul 2017 14:37:41 GMT

Hi,

Thanks for your input.

Could you please elaborate how to catch the unmatched record to compare next day.

Thanks

Shridhar