Thanks for your advice Linus. I compared 1 records between the table in SQL Server and Oracle in HEX./$HEX. The HEX comparison showed no difference, but the transformation incorrectly marked the record as 'changed'. Then I excluded the columns containing null values in the comparison. Still the transformation marked the record incorrectly as changed. So the null values were not the cause for marking the records as 'changed'. The next step was debugging by comparing the columns one by one. The result from debugging was that this comparison is the cause of incorrect marking as 'changed': Sql Server column WERKVOORRAADSPECIALARRANGEMENTS compared with … Oracle WERKVRDSPECIALARRANGEMENTS In my EXTRACT transformation I changed target column name WERKVOORRAADSPECIALARRANGEMENTS (31 characters) into WERKVRDSPECIALARRANGEMENTS (26 characters), and ... now the compare mark the record correctly as 'unchanged'. So this is definately a bug within DI Studio.
... View more