The Definitive Guide to Data Quality
I have similar issue, I searched everywhere but don't know how to get the output into context variable using tOracleRow.
( Have done this with tOracleinput many times (tOracleinput -- tLogRow -- ... --) )
I have created a pl sql block in which I get some data .
--"+ context.REASON +" :=REASON;
-- dbms_output.put_line( DIRECTORY_NUMBER1 );
-- dbms_output.put_line( STATUS_CODE1 );
-- dbms_output.put_line( REASON1 );
dbms_output.put_line ('var_main_1 ' || var_main_1 );
from there I want to get the data in the context variable. I tried many many things but I can't get this done .
My talend flow will be like (tFileInputExecel -- tJavaRow -- tOracleRow)
This is just a POC , We will get number output from this query and I will use bulk collect in my original query if this POC is successful.
Any advice will be appriciated.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.