Incremental load with 2 different databases

[Anonymous]

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.

[manodwhb]

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

[Anonymous]

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

[manodwhb]

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

And then you use the on subjobok then use toracleinput.