I have this error message :
tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante
For this component tOracleOutputBulkExec in update mode it is necessary to describe all fields of the table even the fields which does not go updated?
Thanks in Advance
Not at all.
Are you sure the schema is well defined within your tOracleConnection or tOracleOutputec component?
Yes i am sure.
When i define all fileds in my component tOracleOutputBulkExec it works but when i define just a part of fileds it not works only for update mode.
@pkp85pkp,have you defined fields in tOracleOutputBulkExec schema,which are do not to want to update?
if you please remove those.
i have 2 scenario :
1) i defined all fields of my table in tOracleOutputBulkExec schema,and i update : it is work (picture1)
2) i defined just a part of fields of my table in tOracleOutputBulkExec schema,and i update : it is not work (picture2) merror message : tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante
I did not change anything just the number of fields in the schema !!!
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.