records not seen in database

Six Stars

records not seen in database

Hi,

While transferring data from excel to database table, I found some column mismatch errors which I fixed in both excel and mapping. But atlast it is giving just one error 'ORA-01861: literal does not match format string' and there is column description.Also in the job it shows all the records transferred from Input via tmap to Output, but still because of error none of the records is to be seen in databadberror.jpgse. How to handle this?

 

Fifteen Stars TRF
Fifteen Stars

Re: records not seen in database

Can you share the tMap configuration?

TRF
Ten Stars

Re: records not seen in database

Are you trying to insert a date?
Six Stars

Re: records not seen in database

Yes I am trying to insert Date.

Six Stars

Re: records not seen in database

Ok here it is.date.jpg

Six Stars

Re: records not seen in database

Hello!

Do you have any date field in any of your schemas? You should have a look at them, it seems that you're trying to load some date information as String and your table hold it as a date format.

Could you share your table metadata information?

 

Thank you

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog