topic using context varible in the toracleoutput edit schema in Talend Studio

using context varible in the toracleoutput edit schema

Anonymous — Sat, 16 Nov 2024 08:18:44 GMT

Hi ,

I'am trying to update a column in a table but this column is defined by a context variable.
The problem is that when executin my job the context variable is not recognized.it concider "context.nomColumn" as a column in a table.
Any help plz?

Re: using context varible in the toracleoutput edit schema

vboppudi — Thu, 03 May 2018 22:24:51 GMT

Please provide more details on this. What is your requirement and what you are trying to do in job. If possible job screen shot.

Regards,

Re: using context varible in the toracleoutput edit schema

manodwhb — Fri, 04 May 2018 05:40:49 GMT

@himateja,since you cannot call context variable in schema.when you do Ctrl+Space in the specific place if you get then you can specify the context variables else you could not. As per your requirement you need to go with different approach.so please explain the requirement.

Re: using context varible in the toracleoutput edit schema

Anonymous — Fri, 04 May 2018 06:16:50 GMT

Hi,

i need to develop job for bulk update operations for multiple tables so I a thought of using context variables so we can say what table for Talend to pick up and what columns to pick up and which column to update in the table. But in tamp we cannot use context values to column names and in Toracle op also in scheme we cannot use context variables in dB column name space?

how can we achieve this

Re: using context varible in the toracleoutput edit schema

manodwhb — Fri, 04 May 2018 06:27:45 GMT

@himateja,are you going to have same column in all tables and update the same coulmn?

Re: using context varible in the toracleoutput edit schema

manodwhb — Fri, 04 May 2018 06:43:01 GMT

@himateja,based on your requirement you can use tOracleRow. please check the below link.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/CCdn1_oSeiCZt4Q2dZ1RSg

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/WN0YcNvB1H0c15B8azu74w?section=Raa48944

Re: using context varible in the toracleoutput edit schema

manodwhb — Fri, 04 May 2018 06:43:05 GMT

@himateja,based on your requirement you can use tOracleRow. please check the below links.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/CCdn1_oSeiCZt4Q2dZ1RSg

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/WN0YcNvB1H0c15B8azu74w?section=Raa48944

Re: using context varible in the toracleoutput edit schema

Anonymous — Fri, 04 May 2018 15:48:09 GMT

hi,

but if we use toraclerow it will impact performance since it will update every row.we cant commit like 10000 to 100000 colums right?

Re: using context varible in the toracleoutput edit schema

manodwhb — Mon, 07 May 2018 03:52:59 GMT

@himateja,tOraclerow will work in how DB Query will work,since you can call the commit statement after Insert/Update query.

Re: using context varible in the toracleoutput edit schema

manodwhb — Tue, 22 May 2018 08:41:53 GMT

@himateja,did it help you?