DSXchange

I don't recommend using Teradata Enterprise for what you want to do. You would need to put the custom SQL in the -open or -close properties, but Teradata Enterprise uses a utility slot even if you are loading 0 rows to a dummy table. Use the Teradata API stage.

Sorry, I meant Information Server documentation, not Teradata documentation.

See the Connectivity Guide for Teradata Databases that comes with the Teradata documentation.

No, libtelapi.so is the TPT API library. That library cannot be found either because you have not installed the TPT or its location is not in the LIBPATH/SHLIB_PATH/LD_LIBRARY_PATH. After installing the TPT, it will have placed environment variables such as TWBROOT and NLSPATH in /etc/profile and it...

The original post was for Parallel. Teradata API shows up in the default Teradata stages palette for the server canvas but not for the parallel canvas. Although it doesn't show in the default palette for the parallel canvas, you can still use the Teradata API plug-in on the parallel canvas by draggi...

If you have the data type set to Timestamp, then you need to set the Extended attribute to Microseconds, otherwise the microseconds will get truncated.

Use the Teradata API plug-in. It might not show on the default parallel palette, but you can drag it from Stage Types in the repository view.

You do need to install the TPT to use the Teradata Connector. You can find the TPT on the Load-Unload vol. 2 CD of the Teradata Tools and Utilities.

With the named pipe option, the FastExport process will stream data to a named pipe, and the Teradata MultiLoad plug-in will concurrently read the data from that named pipe. If you turn off the named pipe option, the MultiLoad plug-in will first run FastExport to dump the output to a sequential data...

You could use a Teradata API stage that contains the following queries: DELETE FROM Table1 WHERE condition; DELETE FROM Table2 WHERE condition; etc. You could put the queries in the main SQL or in the Before/After tab depending on whether you want to send in a row for the condition or want to send 0...

Teradata API does not support reject links on the parallel canvas, only on the server canvas. You can use the Teradata Connector on the parallel canvas and it supports reject links, but the Teradata Connector is only available in 8.0.1 FP1.

You might try using the Teradata API stage instead of Teradata Enterprise, since the Teradata API stage doesn't use a utility slot and doesn't have the overhead of connecting multiple sessions at startup. Teradata Enterprise is overkill for what you want to do. If you don't see the Teradata API stag...

The Teradata MultiLoad plug-in uses the external MultiLoad, TPump, and FastExport utilities. The Teradata Load plug-in uses the external FastLoad utility. The Teradata API plug-in uses the standard CLIv2 API. The Teradata Enterprise stage doesn't use the external FastLoad and FastExport utilities, b...

Actually, the second warning is because you only have 2 player processes (maybe your Teradata server has 4 AMPs or you have requestedsessions=4 and sessionsperplayer=2), but you have a 4-node config. That means 2 of your nodes will be unused, since you don't have enough player processes to use all 4...

It means the format of your input data does not match your schema. One of your input records was much shorter than it should have been according to your schema.