Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to pass MYSQL queries in oracle component to get the values by using Talend
Hello,
We suppose you would like to pass a sql query result set to a job and
you could store the result of query to a context variable, and use this variable in oracle component.
For example:
tMysqlInput1--main--tJavaRow
|
onsubjobok
|
tOracleInput--main--tLogRow
on tJavaRow:
context.data=input_row.data;
Elaborating your case with an example with input and expected output values will be preferred.
Best regards
Sabrina
I have 10 reference id in Mysql database table (tMysqlinput) in that i have to take certain reference id to check whether the reference id's are present in the Oracle database(tOracleinput) and get the values in the table format and join with that output values in Oracle .😊