What is plan for f userID and emailID changes on existing users(sys_user) in when imported by Azure

[DK]

Hi All,

there are two companies Big brother an small brother, now small brother company merging with Big brother , so their emplayess records mail's and userID's getting changed as per Big brother company. userID and emailID changes on existing users(sys_user) in when imported by Azure.

I figured out some tables which  get's impacted. : User, Groups, Task, CMDB, RITM, REQ, email, aduit

Kindly let me know Technically what kind of action Plans I need to do.

[Uncle Rob]

I wouldn't focus on tables where users are referenced.
I'd focus around making sure no new user records are created.
So Bob Lahbla is the same sys_user record after the BigBrother as before, just a different user id and email.
The good news is that someone must already be solving that problem.  There is bound to be a data source somewhere that's got original ids and new ids.  
You're going to use that for a large scale data update.

Now you don't have to worry about any of the user references across platform, since the user record retains its original sys_id.

If you've done any code that looks up people by something other than their sys_id though... you're going to have problems.

[DK]

Hi @Uncle Rob ,
Thanks for your reply.

Sys_user : 
So My action should be like this right ? please correct me if I'm wrong here.

1.  To maintain large scale data in proper way , first design DataSource and Transform maps with Defined Template (Original Id's and New Id's). ? so it will cross check OriginalId's records and Update with new ID's right ?

2.  Next day,  when Azure job run, data will be get's loaded and user record get's updated based on newID's right ?