What are the challenges you face when working across database platforms? Take the survey
Options

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.
Tagged:

Best Answer

Answers

  • Options
    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
  • Options
    Thank you @mujtabazeshan - and the same to you! Let me know if you have any further issues!
Sign In or Register to comment.