tTeradataOutput issue when inserting rows

Highlighted
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

Highlighted
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

2019 GARTNER 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

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

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

Blog