Configure downstream transformations to ensure that the dynamic lookup cache and target are synchronized.
When you use a dynamic lookup cache, the
task writes to the lookup cache before it writes to the target table. The lookup cache and target table can become unsynchronized if the task does not write the data to the target. For example, the target database might reject the data.
Consider the following guidelines to keep the lookup cache synchronized with the lookup table:
Use the Router transformation to pass rows to the cached target when the NewLookupRow value equals one or two.
Use the Router transformation to drop rows when the NewLookupRow value equals zero. Or, output the rows to a different target.