Page tree

Release 8.7



Contents:

   

Contents:


This section provides information on how to enable connection to  Teradata . 

  • Teradata provides Datawarehousing & Analytics solutions and Marketing applications. The  Teradata supports all of their Data warehousing solutions. For more information, see http://www.teradata.com.
  • For more information on supported versions, see Connection Types.

This connection supports reading and writing. You can create multiple Teradata connections in the Trifacta application.

Supported Versions: 14.10+

Supported Environments:

Operation

Trifacta Self-Managed Enterprise Edition

AmazonMicrosoft Azure
ReadSupportedSupportedNot supported
WriteSupportedSupportedSupported

Limitations

  • By default, Teradata does not permit the publication of datasets containing duplicate rows. Workarounds:
    • Your final statement for any recipe that generates results for Teradata should include a Remove duplicate rows transformation. 

      NOTE: The above transformation removes exact, case-sensitive duplicate rows. Teradata may still prevent publication for case-insensitive duplicates.

    • It's possible to change the default writing method to Teradata to enable duplicate rows. For more information, contact  Trifacta Support
  • When creating custom datasets using SQL from Teradata sources, the ORDER BY clause in standard SQL does not work. This is a known issue.

Create Teradata Connection

For more information on creating a Teradata connection, see Teradata Connections.

Troubleshooting

ErrorDescription
Duplicate row error

This error occurs when duplicate rows are being inserted during publishing to Teradata.

Workaround: All inserted rows must be unique ,or the Teradata tables must be MULTISET. To configure Trifacta Self-Managed Enterprise Edition to use MULTISET tables, please contact Trifacta Support.


Testing

Steps:

  1. After you create your connection, load a small dataset based on a table in the connected Teradata. See Import Data Page
  2. Perform a few simple transformations to the data. Run the job. See Transformer Page.
  3. Verify the results.

For more information, see Verify Operations.

This page has no comments.