Activity overview
Latest activity by devi_sree
table2: accttype acctnum 1 xxxxx123xxxx 1 xxxx452xxxx 1 xxxx654xxxx 2 xxxxx487xxxx table1: name accttype acctnum Joe 1 123456 John 1 456248 Jame 2 154785 Jxxx 1 457885 Now I want to synchronize table1 with table2 based on accttype column. Now when I do table to table sync, the output is: table1: name accttype acctnum Joe 1 xxxxx123xxxx John 1 xxxxx123xxxx Jame 2 xxxxx487xxxx Jxxx 1 xxxxx123xxxx The expected output is: name accttype acctnum Joe 1 xxxxx123xxxx John 1 xxxx452xxxx Jame 2 xxxxx487xxxx Jxxx 1 xxxx654xxxx So, if you see the output I get, all acctnum for accttype 1 are same. But I need that to be randomly updated as shown. / comments
table2:accttype acctnum1 xxxxx123xxxx1 xxxx452xxxx1 xxxx654xxxx2 xxxxx487xxxxtable1:name accttype acctnumJoe 1 ...
Thank you @TheMaskedData for the answer. In my use case I want acctnum1 to have the same values in acctnum2 column(bcos there is a decoding algorithm that will convert the masked value to valid data, so random synchronization will not work). So while preserving the acctnum2 values I need these values to be randomly updated in acctnum1 column. / comments
Thank you @TheMaskedData for the answer.In my use case I want acctnum1 to have the same values in acctnum2 column(bcos there is a decoding algorithm that will convert the masked value to valid dat...
Random row selection in table to table synchronization.
I have a requirement where the data in one table need to be updated with corresponding data in another table. There is a join column as well which I can use. But the issue is, I need the update to ...