If you edit the table layout
outside of the PDI client,
PDI is not aware of any
field changes, deletions, or additions.
Clearing the cache addresses this issue. The cache needs to be cleared of database-related meta information (field names and their types in each used database table). PDI has this cache to increase processing speed. Perform the following steps to clear this information in the cache from within the PDI client:
- Select the connection.
-
Use either of these methods to
clear the cache: