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 :
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
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema