[If this doesn't already exist I'll submit as an idea]
Is there a way to find (and ideally replace) strings across field mapping expressions in a data sync task? For example if a field name is changed in Salesforce, then a refresh is necessary to update the reference to that field in the field name, however any reference to that field name that is used in, for example, IIF statements does not seem to automatically update. Another example might be if business rules change and a series of expressions using a hardcoded Id need to be updated. Rather than update each expression individually a Search-And-Replace would be great.
This would actually be another great benefit of the ability to reimport XML files of field mappings.
To my knowledge, nothing like this exists in the product today and I haven't heard anyone else request this. If you could submit it as an Idea, that would be helpful. Thanks for all of your feedback!
Will do. I'll include some examples of where one might find it useful.
try the validate mapping button to figure out where the old references are in step 5. it will quickly give you a list of what fields are different now
Also on the import XML mapping, you can reimport the task as powercenter service task. you can't change it anymore, but would allows these overarching search and replaces throughout. you can export your mapping, or what we used to do it put the mouse over the DSS task, look in the bottom left hand corner of the browser to see the taskID, then go into the Secure Agent directory and find the corresponding XML file. Then you can import it in as a powercenter service task.