Activity overview
Latest activity by mujtabazeshan
Hi dOCTOClone - thank you so much for such a quick answer - I really appreciate that Also the topics that you pointed to are great and worth reading I gave the Sync Manager a try and its working great - the only problem is that I have a lot of values to be changed - lets say 25 million in a single table is a start - and the DM is taking more than an hour and half to change these values probably cause there is no index created on the staging table that DM created and it does not give me any option to create one either also I can not change the Substitution Rule in the Sync Manager to a Split Range Manager to speed up the process Well the idea itself is great to try a similar approach like the Sync Manager manually that gave me the advantage of using Split Range Manager and then updating the target table using join really speeds up the process that took about 20-25 mins to update 25 million records in a single table although I am still checking the validity of the data at the moment but its looks good for a start Once again thank you so much for your help and I sure will get back to you if I need any more help Have a lot of great days ahead of you / comments
Hi dOCTOClone - thank you so much for such a quick answer - I really appreciate thatAlso the topics that you pointed to are great and worth readingI gave the Sync Manager a try and its working grea...
CHANGE DISTINCT VALUES
Is there any way I can select DISTINCT values out of a table and then change those values so that all the values in the table get replaced by the new values?????Any help would be greatly appreciated.