Now, you can save your searches to easily repeat search requests.
Saving a search is as easy as 1-2-3:
1. Perform a search. The Search Results page opens. 2. Optionally, choose filters or update your search term. 3. Click Save Search.
You can access saved searches from a list next to the Search field that appears on every page. Saved searches store the search term and any search filters that you apply.
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