New to talend and while learning i was getting Table or view does not exist error while inserting one table data into another table (both tables are in same DB). I have not created the target table and used Action on table option as Create table if does not exist. But when i check the db after this error i was able to see the table created with out data.
Attached the screenshots , please check and let me know what is the solution.
@brahmatalend,since you might not have the table or view in DB or you might not have privillages to read that table/View,which you specified in Table Name or Table name if you rusing Query in Basic settings of tOracleInput.
are you able to select the table out of Talend with the same credentilas?
@brahmatalend,did you provide grant access?
My job is executing but parallelly I get this error in the log 'table or view does not exist'. What would be the issue. Please see the attached screenshot. At the end, some records are not getting the values.
@Alekhya05 ,what is your Target table ? which you have specified in TOracleOutput and which is not there in the DB,may be schema or target table or pointed wrong DB
@Alekhya05 ,for few records only rejecting?
@Alekhya05 , Do you have any constrains on target table?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables