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
What's New With Viewpoint 15.00 Shared Pages

The Shared Pages feature in Viewpoint has been updated to make it simpler and more intuitive. Now, if you want to create a template page to share with others or to ensure that new users are not greeted with a blank Home page, you can find everything you need in the new and improved Shared Pages admin portlet.

udaSQL - A DevOps Focused SQL Execution Engine

"udaSQL" provides a DevOps focused SQL Execution Engine that allows the developer to focus on their SQL and Procedural algorithms while ensuring that the needs of the Operations team are addressed by embedding operational and query logging directly into the engine.

How to Implement Query Banding with Informatica

Every tried to figure out the exact ETL/ELT process that is running some sql statement from within the database..... good luck with that!

Query Banding is part of Teradata's workload management features BUT can also be simply used to trace exactly what process is executing something.

Even if you don't take advantage of the Teradata workload features, every Informatica session that is executed can be determine within Teradata by implementing the query band.

This makes support and performance tuning alot simpler.

Teradata Warehouse Miner - Express Edition

The latest software available for download here is Teradata Warehouse Miner 05.03.05 Express Edition. This is a complete version of the Teradata Warehouse Miner product set, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data.

Cheetah - Distributed In-memory Dual-active Application Engine

Teradata has great perfomance in batch processing. As a typical OLAP system, Tereadata can't peform as well as OLTP in high concurrency real-time application. I wrote an open source framework - cheetah, which tries to work with Teradata together to provide better application experience cross batch and real-time requiements.

Workload Management with User Defined Functions and Table Operators

How does TASM enforce rules such as classification and workload exceptions against User Defined Functions?  What about table functions and table operators, some of which do their work outside of Teradata?  How far can you rely on TASM classifications using estimated processing time in these cases?  Will there be accurate resource usage numbers reported to support workload exceptions on CPU or I/O?

These are some of the questions that need answering if you are extending the use of simple or more complex user-defined functions on your platform.

Performance Testing - When is it time for a System Tune Up?

How do you determine your system’s performance prior to the dreaded customer call asking why their queries are running longer?  What’s the impact to the business when the warehouse environment is under performing?

Teradata Plug-in for Eclipse

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features.

Teradata Studio

Teradata Studio is a client based graphical interface used to perform database administration tasks on the Teradata Database. It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to the article Teradata Studio.

Aster Client Tools

This package contains the Aster client tools.

Pages