Scenario based Question in Talend???

[Prasanna3]

I have csv file loading data into oracle data base while loading i am getting below error.

please check the job design and error screen shot.

 

[iamabhishek]

The error clearly states that the table "ACTOR3" doesn't have any column named "actor_id". You need to make sure of the table schema and perform your task.

[brama]

The error text clearly tells that there is not actor_id column in the table. Please add this column in the table schema and then run the jobs.

Thanks,

Ram

[TRF]

Read the error messages first

[Prasanna3]

Yes 

i read the error and i also defined the schema but still i am getting error.

[Prasanna3]

Yes 

i read the error and i also defined the schema but still i am getting error.

i am getting this error for only loading oracle database i can able to load data successfully into MySQL database

[iamabhishek]

It's not about you have defined the schema or not. It's about the Oracle table that you are referring here in your Talend Job. That table doesn't have the column - so either create the column first in the destination table and load or remove the column from your schema definition and then load.

[Anonymous]

Hi,

     The Actor3 target table do not have the column you are trying to load. You can verify the table structure in Oracle by 

DESCRIBE <tablename>

or 

select * from <tablename>

     If you are still facing the issue, could you please share the table structure screen shot and your component details screen shot?

Warm Regards,

Nikhil Thampi

[Anonymous]

In tDBBulkExec check for the column actor_ID exists in the table Actor3