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

[desanip]

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

[Anonymous]

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

[desanip]

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?