Aster Analytic Tables and Persistence | Teradata Studio - Aster Analytic Tables and Persistence - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Analytic tables hold data across the span of several transactions, sessions, or days. You can use analytic tables only for derived data and never for original source data. If data needs to persist longer than a few days, consider using a Regular table.
Regular (persistent) tables are only available for regular Aster database connections, not Aster Execution Engine (Aster-on-Hadoop) connections.
  • Analytic tables are not replicated, and do not survive a system restart.
  • Analytic tables may be FACT or DIMENSION tables (non-replicated).
  • Analytic tables do not support columnar storage.
  • You can perform a logical backup and restore for analytic tables. Physical backup and restore are not supported.
  • You can create analytic tables as logically partitioned tables. This results in the entire table hierarchy being analytic.
  • Do not create analytic tables as parent/child tables with inheritance.