Optimizing Large Data Loads in Data Services Using Persistent Cache

Persistent cache will play vital role in BODS when we are handling large datasets. This feature helps us lookup or join large volumes of data.

Persistent Cache can be created using Data Service Designer as a database in the local repository which gives it a performance edge when compared to normal cache in lookups.

Create a separate dataflow to load data from the source table into the persistent cache target template table. When you load/reload data into a persistent cache template table, the persistent cache database will always get truncated and recreated into the path location. Once the table is created, you can use it in your actual job.