Transforms Involving Database Queries

Of all the PSP methods (transforms) provided by the Row Set Transformation Toolkit business service, those that involve database queries are the following:

• Simple Look-Up

• Query

• Hierarchical Look-Up

• Rule Set Look-Up

• Dynamic Look-Up

There are two ways that PSP Cache is implemented: one is special for the Dynamic Look-Up transform, and the other is for the rest of the transforms:

• PSP Dynamic Look-Up Transform Cache. This cache is used when the Dynamic Look-Up transform performs a query. For more information, see About Using the PSP Dynamic Look-Up Transform Cache.

• PSP Generic Cache. This cache is used when all transforms other than the Dynamic Look-Up transform perform a query. For more information, see Using the PSP Generic Cache.

The following topics contain more information about PSP Cache:

• Enabling PSP Cache

• Setting Cache Size

• Using the PSP Generic Cache

• Optimizing PSP Cache

• Defining a Cache Refresh Key

• Configuring a Clear Cache Button

• About Using the PSP Dynamic Look-Up Transform Cache

• About PSP Cache Performance Statistics