Managing tables, views, and load queries

Tables and views are global objects that are available to all applications within a tenant. The content of a model (scripts, load queries, and OLAP model) is application specific.

Load queries and scripts are stored in applications. We recommend that you use a single application for the load queries of each table.

If your relational model is the source for several applications, we recommend that you use prefixes to identify which tables and views are used by which applications.

You can export elements of a model from the Staging and Integration databases.