TD_MINFO Function | Teradata Vantage - TD_MINFO - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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