we are moving from the security incident table to the custom security table which is same as security incident table. we have 17 client which are domain separated, and security table is in the domain A and custom security table is in domain for this data migration we using export the data from the list view and importing using load data (import set table and transform map)
1.The attachment should also be populated into the custom table (for this i wrote fix script in global domain but it RCA warning )
2.The activity stream should be same as the record in the security table (the record getting created as per the user who run the import set, but it should be like the original creator and only latest work notes are getting added but all the work notes on the record should be copied)
The record we are importing into the custom security table should be same as security table
please suggest best approach to achieve this
