topic tOracleOutput log rejected rows in Talend Studio

tOracleOutput log rejected rows

Anonymous — Fri, 11 Oct 2013 12:59:12 GMT

Hi all I've to log the rejected rows of a tOracleOutput component but since that I've a lot of jobs that load the data in the DB I need to create a generic log process that takes as input a string and write this information on a file.
Is there a way to convert a rejects row (that is coming out from a tOracleOutput) to a flat String with the "|" as separator ? Without using the tMap (Exactly like th tlogRow).
Regards

Re: tOracleOutput log rejected rows

Anonymous — Sat, 12 Oct 2013 03:56:34 GMT

Hi,
You can link a output component, such as, tfileoutputdelimited to tOracleOutput. The reject rows should be kept in flat file.
Feel free let me know if it is OK with you job.
Best regards
Sabrina

Re: tOracleOutput log rejected rows

Anonymous — Mon, 14 Oct 2013 11:29:10 GMT

That is the approach that I'm using now but I want to send the entire row to a subjob that is used to log the information on the file. I don't know how to achieve this

Re: tOracleOutput log rejected rows

Anonymous — Mon, 14 Oct 2013 11:36:10 GMT

Hi,

That is the approach that I'm using now but I want to send the entire row to a subjob that is used to log the information on the file. I don't know how to achieve this

That means you want to set the tOracleOutput as input source of subjob, right? If so, please show us your current design screenshot, we will see if there is any good option for it.
Best regards
Sabrina

Re: tOracleOutput log rejected rows

Anonymous — Mon, 14 Oct 2013 11:46:57 GMT

Sure attached the job that I've created.
I need to pass the rejected rows of the job tOracleoutput1 in a generic log sub-job like the existing blocks LOG_SUPPLIER_LOADING jobs (that at the moment accept simple parameters). Think that I've 102 processes to change for this reason I wanna try to generalize the log process.
Regards