O'Reilly logo

Teradata Aster Data by John Nolan, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6 - Temporary and Analytic Tables

“A Journey of a thousand miles begins with a single step.”

-Lao Tzu

Aster has Three Types of Data

There are three different types of tables with different levels of persistence:

image Regular or Persistent Tables – These are normal tables that continue to exist along with its data until they are dropped. The table persists across sessions as well as through multiple transactions. The table survives system restarts, adding or removing of nodes, any partition splitting, all backup and restore operations, and importing or exporting.

Temporary Tables – These persistent only for one transaction. Once the transaction ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required