Hi Joel, I haven¹t dealt with this personally, but could ask around. I guess though there are numerous ways to go about with this, depending on the exact needs. The two that come to mind first:
You could create a permanent solution using Flexible Replication, which builds on top of CPF: http://docs.marklogic.com/guide/flexrep/rep_intro#id_62963 You could also use MLCP copying feature together with an MLCP transform. You already mentioned triggers and scheduled tasks, but MLCP will load faster I think. CPF uses triggers underneath.. Kind regards, Geert On 3/24/15, 2:12 AM, "Joel Wilson Gunasekaran" <[email protected]> wrote: >Hi, > >Once in a while, we refresh dataset in lower environments with production >data for testing purposes. >We have a requirement to mask all pii(personally identifiable >information) data like email id, phone number, etc. in lower environments >like DEV, QA. > >We were thinking about having a one-time script that does the masking, >which can be run when we do the data refresh. >In addition to this, we also want a automated process that does this, >like either a scheduled task or a trigger, to avoid any sensitive data >left unmasked, accidentally. > >Can you please let me know if you have had to deal with similar cases and >any suggestions? > >Thanks >Joel >_______________________________________________ >General mailing list >[email protected] >http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
