using context varible in the toracleoutput edit schema

Five Stars

using context varible in the toracleoutput edit schema

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?

135430_context.PNG

Nine Stars

Re: using context varible in the toracleoutput edit schema

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,

Veeru Boppudi
Forteen Stars

Re: using context varible in the toracleoutput edit schema

@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.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: using context varible in the toracleoutput edit schema

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

Forteen Stars

Re: using context varible in the toracleoutput edit schema

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: using context varible in the toracleoutput edit schema

@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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: using context varible in the toracleoutput edit schema

@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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: using context varible in the toracleoutput edit schema

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?

Forteen Stars

Re: using context varible in the toracleoutput edit schema

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: using context varible in the toracleoutput edit schema

@himateja,did it help you?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads