PDI does not recognize changes made to a table
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:
Tools > Database > Clear Cache
Database connections > Clear complete DB cache
PreviousForce PDI to use DATE instead of TIMESTAMP in Parameterized SQL queriesNextJobs scheduled on Pentaho Server cannot execute transformation on remote Carte server
Last updated
Was this helpful?