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 ?
![](https://higherlogicdownload.s3.amazonaws.com/HITACHI/MessageImages/da2d17ee02f54f83b45ae541451047f1.png)