The documentation portal is undergoing maintenance. During this period, you can't create any new user credentials. If you do, you'll need to recreate the user credential after the maintenance period ends.
You can use the SELECT statement to access virtual tables that contain metadata information. These virtual tables reside in a virtual schema named ADMIN_SCHEMA. The ADMIN_SCHEMA schema resides in the metadata database in the Data Vault.
Use the following syntax to access a virtual table:
SELECT * from ADMIN_SCHEMA.<table name>
Example:
SELECT * from ADMIN_SCHEMA.TABLES
You can access the following virtual tables:
ADMIN_SCHEMA.TABLES
ADMIN_SCHEMA.PARTITIONS
ADMIN_SCHEMA.COLUMNS
ADMIN_SCHEMA.DOMAINS
ADMIN_SCHEMA.PART_LIMITS
ADMIN_SCHEMA.TAB_LIMITS
ADMIN_SCHEMA.HOSTS
ADMIN_SCHEMA.AGENTS
ADMIN_SCHEMA.TASKS
ADMIN_SCHEMA.CLIENTS
ADMIN_SCHEMA.SESSIONS
ADMIN_SCHEMA.USERS
ADMIN_SCHEMA.DATABASES
ADMIN_SCHEMA.ADMINS
ADMIN_SCHEMA.VERSIONS
For more information, see the
Informatica Data Archive 6.2 HotFix 2 Data Vault Administrator Guide