Monitoring and managing the cashe is cache management.There are three ways to do that.

Disable caching for the system.(NSQconfig INI file), Cache persistence time for specified physical tables and Setting event polling table.

Disable caching for the system.(INI NQ CONFIG file :

You can disable caching for the whole system by setting the ENABLE parameter to NO in the NQSConfig.INI file and restarting the Siebel Analytics Server. Disabling caching stops all NEW cache entries and stops any new queries from using the existing cache. Disabling caching allows you to enable it at a later time without losing any entries already stored in the cache.

Cache persistence time for specified physical tables:

You can specify a cacheable attribute for each physical table; that is, if queries involving the specified table can be added to the cache to answer future queries. To enable caching for a particular physical table, select the table in the Physical layer of the Administration Tool and select the option MAKE table cacheable in the General tab of the Physical Table properties dialog box. You can also use the Cache Persistence Time settings to specify how long the entries for this table should persist in the query cache. This is useful for OLTP DATA sources and other data sources that are updated frequently, potentially down to every few seconds.

Setting event polling table:

Siebel Analytics Server event polling tables store information about updates in the underlying databases. An application (such as an application that loads data into a data mart) could be configured to add rows to an event polling table each time a database table is updated. The Analytics server polls this table at set intervals and invalidates any cache entries corresponding to the updated tables.

For event polling table ,It is a standalone table and doesn’t require to be joined with other tables in the physical layer.

Monitoring and managing the cashe is cache management.There are three ways to do that.

Disable caching for the system.(NSQconfig INI file), Cache persistence time for specified physical tables and Setting event polling table.

Disable caching for the system.(INI NQ config file :

You can disable caching for the whole system by setting the ENABLE parameter to NO in the NQSConfig.INI file and restarting the Siebel Analytics Server. Disabling caching stops all new cache entries and stops any new queries from using the existing cache. Disabling caching allows you to enable it at a later time without losing any entries already stored in the cache.

Cache persistence time for specified physical tables:

You can specify a cacheable attribute for each physical table; that is, if queries involving the specified table can be added to the cache to answer future queries. To enable caching for a particular physical table, select the table in the Physical layer of the Administration Tool and select the option Make table cacheable in the General tab of the Physical Table properties dialog box. You can also use the Cache Persistence Time settings to specify how long the entries for this table should persist in the query cache. This is useful for OLTP data sources and other data sources that are updated frequently, potentially down to every few seconds.

Setting event polling table:

Siebel Analytics Server event polling tables store information about updates in the underlying databases. An application (such as an application that loads data into a data mart) could be configured to add rows to an event polling table each time a database table is updated. The Analytics server polls this table at set intervals and invalidates any cache entries corresponding to the updated tables.

For event polling table ,It is a standalone table and doesn’t require to be joined with other tables in the physical layer.