Dynamic Lookup Cache and Output Values
If you enable a dynamic lookup cache, the output port values vary based on how you configure the dynamic lookup cache. The output value of the lookup/output port depends on whether you choose to output old or new values when the Integration Service updates a row.
You can configure the Output Old Value On Update property to specify one of the following types of output values for a lookup/output port:
- •Output old values on update. The Integration Service outputs the value that existed in the cache before it updated the row.
- •Output new values on update. The Integration Service outputs the updated value that it writes in the cache. The lookup/output port value matches the output port value.