Welcome! Teradata Developer Exchange is a community-oriented website that connects Teradata Associates with Customers and others interested in the related technologies. Think of it as a technical collaborative community for sharing ideas, asking questions, learning, and solving problems related to Teradata solutions and beyond. Sounds great doesn't it? So sign up and join the community now!

Expand All Subscribe to Teradata Developer Exchange - All content The Latest
The Life of a Teradata Query

This presentation will follow a Teradata SQL query from its origin at the client...

Using Aster Express: Act 3, On the Road to nPath

The foundations of the Aster platform are a parallel database with all the features you'd expect from a SQL platform.  However the power of the Aster platform really shines once you start using its library of SQL-MR analytic components.  With these components, complex data analysis that is difficult to code in SQL becomes much, much easier.  A clear example of this can be seen with Aster's nPath module.

.NET Data Provider Reference

The following reference documentation is available:

Episode IV: A New Platform (Backbone.js + Require.js)

This is the final installment of a four part series on modularizing the Backbone.js Todos application using Require.js. It examines porting the application to the Pokki platform. 

9.2 Quintillion? What's that all about?

A quintillion is 10 raised to the power of 18 (that is, 1 followed by 18 zeros).  9.2 quintillion (or more precisely, 9,223,372,036,854,775,807) is the new limit in Teradata Database 14.0 for the number of combined partitions.  Note that this is the same as the maximum BIGINT value (which is a signed 8-byte integer).  While tables that are defined with 65535 or less combined partitions still use 2-byte partitioning, if the number of defined combined partitions exceeds 65535 for a table, the table is created with 8-byte partitioning.

The Initialization process of the NPAM

The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad). The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer.

The reader process will initialize the NPAM module via an Initialization string and this article details the various parameters that are initialized during this process.

Changes to the TASM AMP Worker Task Event in Teradata 13.10

AMP worker tasks are the dedicated tasks inside each AMP that get the database work done.  As there are a limited number, this important resource is actively monitored by DBAs on busy systems.  TASM system-level events can take care of the monitoring for you, and based on a threshold you have set set, will trigger changes in workload management setup to manage the AWT shortage.  How AMP worker task events do their monitoring has changed in Teradata Database 13.10, and this posting describes those changes.

Different operating modes of the NPAM

The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).  The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer.

This article details the different modes in which Named pipes are opened and used by NPAM for data transfer activity.

Two Turn Tables and a Mixin

This blog entry provides a brief introduction to underscore.js mixins.

Rows versus Columns? Why Not Both?

This presentation introduces the new optional columnar capabilities coming in Teradata 14.

Pages