DSXchange

My mistake, support for BIGINT in the Teradata Connector isn't in the base 8.0.1 FP1, but it is available in a patch to FP1. Get the patch for Ecase 125205. There is an 8.0.1 FP1 patch for AIX. If you need a patch for a different platform, you'll need to contact your IBM support to have a patch buil...

The "Error writing to pipe: Broken pipe" message means that the Teradata MultiLoad stage is still writing to the named pipe, but the MultiLoad utility has stopped reading from the named pipe because it aborted for some reason. Check the MultiLoad report file and see if it contains any info...

Teradata introduced BIGINT in V2R6.2. That data type is supported by the Teradata Connector in Information Server 8.0.1 FP 1.

In a normal lookup, the lookup data set is populated at the start of the job from the contents of the lookup table. Each main input row into the lookup stage causes a probe into that data set. With a normal lookup, you have the option of using the connector's Bulk access method to populate the looku...

Open the Teradata Enterprise stage. From the Properties tab of the Input page, click on Options folder and you'll see the Open Command option in the window of "Available properties to add". Click on it to add that option, type in your DELETE statement in the Open Command field.

Your best option is to use the Teradata Enterprise stage. Since you have a range of values you want to pre-delete, you can do that in the -open option of Teradata Enterprise. You should be able to pass the constraint value via a job parameter. After the pre-delete, it's preferrable to use Teradata E...

I would expect the length of a TIMESTAMP(0) to be 19 (YYYY-MM-DD HH:MM:SS).

Is it possible that you are setting the Extended attribute on the Timestamp column to Microseconds? You should not set that attribute. Intead you should leave it blank. Since your target table's column is defined as TIMESTAMP(0), you don't want the Microseconds extended attribute.

Rather than changing the DDL of your target table column to CHAR(19), you should change the data type of your input link column to Timestamp.

The Teradata client consists of several CDs. What are the CD titles that came with your Teradata 12 client? Are there a couple titled Load-Unload? The one titled Load-Unload vol. 1 is the one that has the utilities such as fastload, mload, tpump, and fexp.

You should be using the Teradata Enterprise stage.

I believe there is already a patch for this issue. Look for a patch for e104775.

The ODBC Connector is a new stage in Information Server 8.

Use a connector such as the ODBC Connector. The connectors support LOBs whether passed inline or by reference. If the LOB is truly too large to pass inline, pass it by reference. The downstream connector will read the LOB from the upstream connector in chunks. When passing by reference, you definite...

I have not installed the Teradata 12 client, but as far as I know the original utilities have not been decommissioned. They are still available in addition to the TPT. In TTU 8, the utilities were on the Load-Unload vol. 1 CD. I assume the same is true in Teradata 12.