topic Re: Incremental load with 2 different databases in Talend Studio

Incremental load with 2 different databases

Anonymous — Sat, 16 Nov 2024 02:48:32 GMT

Hi,

I am new to incremental load looking out for some help.

Job Description :

Trying to implement the incremental load by using 2 different databases where source is oracle and target is postgresql. I only have read access in source database so not able to create any lookup table in the same. trying to implementing the same by using tJavarow component for that I have created 1 lookup table in my target db and fetching max(updated_date) into tJavarow component but I am not sure how to pass input from this component to next component i.e.toracleinput_1

below is my job design for reference. Also suggest me if you have any other solutions.

Re: Incremental load with 2 different databases

manodwhb — Fri, 03 Apr 2020 01:55:00 GMT

You need to load into context variable or global variable in tjavarow, which you need to use in toracleinput.

Re: Incremental load with 2 different databases

Anonymous — Fri, 03 Apr 2020 07:06:38 GMT

Can you please elaborate it more like where to set the global variable and where I supposed to modify the design. It will help me

Re: Incremental load with 2 different databases

manodwhb — Fri, 03 Apr 2020 09:14:24 GMT

In tjavarow you can set as context variable. Like
context.date=Input_row.date:

And then you use the on subjobok then use toracleinput.