One Star

Update tOracleOutput field that matches a tOracleInput field value

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.
6 REPLIES
One Star Lie
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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

Regards,
Lie
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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.
One Star Lie
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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

Regards,
Lie
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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.
One Star Lie
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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.
One Star

Re: Update tOracleOutput field that matches a tOracleInput field value

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.