Menu
I have a Informatica session which is linked to a wrong mapping. How do i change the mapping from M1 to M2 in the same session S1 and Workflow W1 WITHOUT importing/exporting as XML and making the changes ???
842
An easy way in PowerCenter to replace a mapping in a session is to invalidate the mapping and then to refresh the session in the workflow. It then prompts for a new mapping to associate.
A session is a task, similar to other tasks available in the Workflow Manager. You create a session for each mapping that you want the Integration Service to run. The Integration Service uses the instructions configured in the session and mapping to move data from sources to targets.
XML export.Export the session object and then edit the xml file where you need to change the mapping name. Now when you'd import it, it'll ask for the mapping to associate with. This way you can do it.
Invalidate the current mapping temporarily and refresh the session. This would allow you to choose a different mapping for your session. Pick the new one.
Don't forget to validate your old mapping.
Source: ITTOOLBOX
106
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
