topic Re: Update tOracleOutput field that matches a tOracleInput field value in Talend Studio

Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Sat, 16 Nov 2024 13:26:16 GMT

Hello everybody,
How can I build a job that updates a tOracleOutput field, only when a tOracleOutput Id (Identification Field) field equals a tOracleInput Id field?.
Thanks a lot in advance,
Gracia.

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Tue, 11 May 2010 09:45:00 GMT

Hi
Can you be more accurate on which components performs what ?
You may solve your problem by using tMap and/or tFilterRow.

Regards,
Lie

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Wed, 12 May 2010 16:03:31 GMT

Hi
Can you be more accurate on which components performs what ?
You may solve your problem by using tMap and/or tFilterRow.

Regards,
Lie

Hello Lie,
Thanks for your answer :-). Using a tMap is OK. How can I define the condition over a tOracleInput field at the tOracleOutput?.
Thanks a lot again in advance :-),
Gracia.

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Wed, 12 May 2010 16:21:45 GMT

Hi,
You can use conditions as shown in my example below.
Is this what you were looking for ?

Regards,
Lie

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Thu, 13 May 2010 09:10:07 GMT

Hi,
You can use conditions as shown in my example below.
Is this what you were looking for ?

Regards,
Lie

Hello Lie,
yes, but with the tOracleOutput field "number". I mean, how willl you type the condition "row1.number = number" at the tMap?.
Regards, and thanks a lot,
Gracia.

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Fri, 14 May 2010 11:01:21 GMT

Hmm...
I suppose you have a global flow of data and you want to filter datas which id equals to one in your input flow, then update datas in the database ? Am I right ?
If that's the case, use a tJoin, map your global flow id with your input flow id. The result should be only lines which has id in your input flow. The tOracleOutput should perform only on those lines.
It should be as easy as in my example below if I understood your problem.

Re: Update tOracleOutput field that matches a tOracleInput field value

Anonymous — Fri, 14 May 2010 11:47:14 GMT

Hmm...
I suppose you have a global flow of data and you want to filter datas which id equals to one in your input flow, then update datas in the database ? Am I right ?
If that's the case, use a tJoin, map your global flow id with your input flow id. The result should be only lines which has id in your input flow. The tOracleOutput should perform only on those lines.
It should be as easy as in my example below if I understood your problem.

Hello Lie,
yes, you're right 🙂 , that's what I need. I'm going to try this solution.
Thanks a lot for your great help! ,
Gracia.