Optim Test Data Management for Teradata: Load techniques and performance tips

From the developerWorks archives

Mitesh Shah

Date archived: January 12, 2017 | First published: November 01, 2012

Whether it's about managing database archive life cycle, application decommissioning, or test data management using InfoSphere® Optim®, the performance challenges remain the same. A narrow maintenance window, moving billions of rows, complex architecture, and limited hardware resources all contribute to performance in some way or the other. This article provides an insight into best practices and comparisons of various load mechanisms in Optim support for Teradata, along with performance considerations for the same.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=842892
ArticleTitle=Optim Test Data Management for Teradata: Load techniques and performance tips
publish-date=11012012