To configure data object caching, configure the cache database connection for the Data Integration Service.
Then, enable caching for each logical data object or virtual table that end users access frequently.
Perform the following steps to configure data object caching:
Configure the cache database connection in the cache properties for the Data Integration Service.
The Data Object Cache Manager creates the cache tables in this database.
Enable caching in the properties of logical data objects or virtual tables in an application.
When you enable caching, you can also configure the Data Integration Service to generate indexes on the cache tables based on a column. Indexes can increase the performance of queries on the cache database.