TD_MINFO Function | Teradata Vantage - TD_MINFO - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
TD_MINFO returns one row for each matrix instance found in the target table. The summary provides a high-level understanding of the matrix data as well as determining if there is an issue. For example, if you expect data to have a certain number of rows and columns, a certain data type, or only a specific range of values, then checking the summary information can verify it. Each returned row provides the following information about a matrix:
  • Row index data type
  • Starting row index value
  • Ending row index value
  • Number of row index entries
  • Indicator that the matrix is regular (discrete) or irregular along row index
  • Row index sample interval for regular series or average sample interval for irregular series
  • Column index data type
  • Starting column index value
  • Ending column index value
  • Number of column index entries
  • Indicator that the matrix is regular (discrete) or irregular along column index
  • Column index sample interval for regular series or average sample interval for irregular series
  • Content type
  • Minimum sample magnitude
  • Maximum sample magnitude
  • Average sample magnitude
  • Number of NULL values
  • Indicator matrix is well formed or malformed