tTeradataOutput issue when inserting rows

Four Stars

tTeradataOutput issue when inserting rows

Hi everyone,

I did a Talend job where I basically just insert some transformed row into a Teradata table but I experience an issue that is really weird.

Here's my Talend job : 

 

Question_Teradata.PNG

It shows me that the row has been inserted but when I query my database, it is not here...

 

Has anybody already experienced the same issue ?

 

P.S : Things I already did : - Transform all the fields into String 

 

Thanks in advance

Employee

Re: tTeradataOutput issue when inserting rows

Hi,

 

     I believe you are inserting the data to a table where the data type is not string. I assume you must not have selected Die on error in your tTeradataOutput and that could be the reason why the job is not failing.

 

     Could you please share the component screenshot (basic and advanced) of the problematic component if the error persists? I would like to see the schema you have defined in the tTeradataOutput and the schema of the actual Teradata table,

 

     If the reply has helped you to identify the issue and resolve it, could you please mark the topic as closed? Kudos are also welcome :-)

 

Warm Regards,

 

Nikhil Thampi

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now