I am trying to implement row level identification in the target in informatica. The mappings are already present and links are already made but i want this change to be implemented in more than 1000 mappings. How can i do this without affecting the current mapping as it become very tedious to add column in expression in 1000 mappings manually. Is there a better way to do this. Please tell. If my question is not understood please ask.
This is a very complex task. There is no out-of-the-box solution to accomplish that, I'm afraid. What you could do, is export all the mappings to XML and work on the exported definitions to add the required feature. Then import the definitions back. This however requires some analysis to understand the way mappings are built as well as the details of your requirement.