Pentaho

 View Only

 Large Table Sync between Database

Chan Patel's profile image
Chan Patel posted 07-02-2024 12:33

Hi All,

I have been trying to sync few tables between Oracle (Primary) to MySQL (DataWarehouse) using Synchronize after Merge Step and it has been working fine, however I have few tables which have too many rows and are wide, takes like a few hours to update. If I truncate the table and re-run it, it even takes longer, below is a sample of the setup I have created.

Any suggestions to increase the performance ?