SAS/Warehouse Administrator Metadata Types
|
Category |
SAS/Warehouse Administrator Metadata Type |
Description |
|
Column Types |
WHCOLDAT
|
Metadata type for data table columns |
|
WHCOLDTL
|
Metadata type for detail table columns |
|
WHCOLODD
|
Metadata type for ODD columns |
|
WHCOLOLP
|
Metadata type for OLAP columns |
|
WHCOLSCL
|
Metadata type for statistic columns in summary tables
and MDDBs |
|
WHCOLSUM
|
Base metadata type for columns in summary tables and
MDDBs |
|
WHCOLTIM
|
Metadata type for _LOADTM columns |
|
WHCOLUMN
|
Base metadata type for table columns |
|
Extended Attribute Type |
WHEXTATR
|
Metadata type for extended attributes |
|
Global Metadata Types |
WHDBMS
|
Metadata type for DBMS connection definitions |
|
WHHOST
|
Metadata type for host definitions |
|
WHPERSON
|
Metadata type for person records |
|
WHSERV
|
Metadata type for the scheduling server |
|
WHSRVAT
|
Metadata type for the Windows NT AT scheduling server |
|
WHSRVCRN
|
Metadata type for Unix Cron scheduling server |
|
WHSRVNUL
|
Metadata type for the Null scheduling server |
|
Index Type |
WHINDEX
|
Metadata type for indexes that are associated with tables
and columns |
|
Object Types--Explorer |
WHDATTBL
|
Metadata type for data tables |
|
WHDETAIL
|
Metadata type for detail tables |
|
WHDW
|
Metadata type for data warehouses |
|
WHDWENV
|
Metadata type for warehouse environments |
|
WHGRPDAT
|
Metadata type for data groups |
|
WHGRPINF
|
Metadata type for InfoMarts |
|
WHGRPODD
|
Metadata type for ODD groups |
|
WHGRPOLP
|
Metadata type for OLAP groups |
|
WHGRPSUM
|
Metadata type for summary groups |
|
WHINFO
|
Metadata type for InfoMart items |
|
WHINFOFL
|
Metadata type for InfoMart files |
|
WHLDETL
|
Metadata type for detail logical tables |
|
WHODDTBL
|
Metadata type for ODDs |
|
WHOLPMDD
|
Metadata type for OLAP MDDBs |
|
WHOLPSTC
|
Base metadata type for OLAP tables, groups, and MDDBs |
|
WHOLPTBL
|
Metadata type for OLAP tables, groups, and MDDBs |
|
WHSUBJCT
|
Metadata type for subjects in a warehouse |
|
WHSUMDDB
|
Metadata type for SAS Summary MDDBs |
|
WHSUMTBL
|
Metadata type for summary tables |
|
WHTABLE
|
Base metadata type for tables |
|
Object Types--Intermediate Output Tables |
WHTBLMAP
|
Metadata type for intermediate output tables that are
produced by column mapping processes |
|
WHTBLPRC
|
Base metadata type for intermediate output tables that
are produced by processes |
|
WHTBLREC
|
Metadata type for intermediate output tables that are
produced by record selector processes |
|
WHTBLUSR
|
Metadata type for intermediate output tables that are
produced by user exit processes |
|
WHTBLXFR
|
Metadata type for intermediate output tables that are
produced by data transfer processes |
|
Object Types--OLAP |
WHOLAP
|
Base metadata type for OLAP dimension, hierarchy, and
crossing |
|
WHOLPCRS
|
Metadata type for OLAP crossing |
|
WHOLPCUB
|
Metadata type for OLAP cube |
|
WHOLPDIM
|
Metadata type for OLAP dimension |
|
WHOLPHIR
|
Metadata type for OLAP hierarchy |
|
Object Types--Process Editor |
WHEFILE
|
Metadata type for external file inputs to ODDs |
|
WHEVENT
|
Metadata type for events |
|
WHGRPJOB
|
Metadata type for job groups |
|
WHJOB
|
Metadata type for jobs |
|
WHODTTBL
|
Metadata type for ODTs (Data Files) |
|
WHPOBJCT
|
Metadata type for the Process Editor |
|
Object Types |
WHOBJECT
|
Base metadata type for SAS/Warehouse Administrator
objects |
|
Physical Storage Types |
WHDBMSST
|
Metadata type for DBMS physical stores |
|
WHDYNSAS
|
Metadata type for dynamically generated SAS physical
stores |
|
WHMDDSTR
|
Metadata type for OLAP MDDB physical store |
|
WHPHYSTR
|
Base metadata type for physical storage objects |
|
WHSASSTR
|
Metadata type for SAS physical data stores |
|
Process Types--Load |
WHLDOMDD
|
Metadata type for OLAP MDDB load processes |
|
WHLDOPRX
|
Metadata type for OLAP Proxy load processes |
|
WHLDOTBL
|
Metadata type for OLAP table load processes |
|
WHLDRDAT
|
Metadata type for data table load processes |
|
WHLDRDTL
|
Metadata type for detail table load processes |
|
WHLDREXT
|
Metadata type for external file load processes |
|
WHLDRIMF
|
Metadata type for InfoMart file load processes |
|
WHLDRINF
|
Metadata type for InfoMart item load processes |
|
WHLDRLDT
|
Metadata type for detail logical table load processes |
|
WHLDRMDB
|
Metadata type for SAS MDDB load processes |
|
WHLDRODD
|
Metadata type for ODD load processes |
|
WHLDRODT
|
Metadata type for ODT (Data File) load processes |
|
WHLDRSUM
|
Metadata type for summary table load processes |
|
WHPRCLDR
|
Base metadata type for table load processes |
|
Process Types |
WHCTRNFM
|
Metadata type for column transformations |
|
WHPRCMAN
|
Base metadata type for main processes |
|
WHPRCMAP
|
Metadata type for data mapping processes |
|
WHPRCPST
|
Metadata type for post-load processes |
|
WHPRCREC
|
Metadata type for record selector processes |
|
WHPRCSPR
|
Base metadata type for subprocesses |
|
WHPRCUSR
|
Metadata type for user exit processes |
|
WHPRCXFR
|
Metadata type for data transfer processes |
|
WHPROCES
|
Base metadata type for processes |
|
WHROWSEL
|
Metadata type for a row selector |
|
WHSUBSET
|
Metadata type for subsetting processes that are associated
with data mappings |
|
Root Metadata Type--SAS/Warehouse Administrator |
WHROOT
|
Root type for all SAS/Warehouse Administrator metadata
types |
|
SAS Library Types |
WHDYNLIB
|
Metadata type for dynamic SAS libraries |
|
WHLIBRY
|
Base metadata type for SAS libraries |
|
WHREPLIB
|
Metadata type for metadata repositories |
|
Text File Types |
WHDYNSRC
|
Metadata type for dynamically generated source code
entries in SAS catalogs |
|
WHJOBCAT
|
Metadata type for scheduler catalog source file entries |
|
WHJOBFIL
|
Metadata type for scheduler external file entries |
|
WHNOTE
|
Metadata type for notes |
|
WHSCRFIL
|
Metadata type for SAS/CONNECT script files |
|
WHSRCCAT
|
Base metadata type for SAS catalog entry source code
files |
|
WHTFILE
|
Base metadata type for text files |
|
WHTXTCAT
|
Base metadata type for SAS catalog entry text files |
|
WHTXTFIL
|
Base metadata type for external text files |
