Six Stars

Convert PLSQL code into talend

Hi Team,

 

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

 

I have attached the code. 

 

Thanks

Shridhar

 

4 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Convert PLSQL code into talend

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.

TRF
Six Stars

Re: Convert PLSQL code into talend

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.

 

 

Twelve Stars TRF
Twelve Stars

Re: Convert PLSQL code into talend

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.

TRF
Six Stars

Re: Convert PLSQL code into talend

Hi,

 

Thanks for your input.

 

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

 

Thanks

Shridhar