topic Re: Load file to Teradata table( Insert,update,delete options) using TPT or TPump in Talend Studio

Load file to Teradata table( Insert,update,delete options) using TPT or TPump

desanip — Sat, 16 Nov 2024 01:18:14 GMT

Hello Talendians,

Can someone tell me what is the right component to load a file( has about 1 M records) to a teradata table? I see options like tTeradataTPTExec and tTeradataTPump.

When i try to use these, i run into following error;

Exeception in component Tteradatatptexec:

java.io.IOException: Cannot run program "cmd" : error=2. No such file or directory

I have TPT installed on server. I checked it by typing "tbuild"

Anyhelp would be appreciated

Re: Load file to Teradata table( Insert,update,delete options) using TPT or TPump

Anonymous — Wed, 14 Oct 2020 08:41:56 GMT

Hello,

Is it a PATH issue?

Please ensure the JAVA_HOME and PATH are configured with the correct Java installed locations and you are able to successfully execute the java -version command.

Best regards

Sabrina

Re: Load file to Teradata table( Insert,update,delete options) using TPT or TPump

desanip — Fri, 16 Oct 2020 01:17:25 GMT

Hello Sabrina,

I am running this on a job server and not on my local machine. I ran the command java -version. I also ran the command tbuild and mload and i can tpt and mload utility installed on the server. What should i check over there? Can you provide any suggestion?