This content has been marked as final. Show 2 replies
It doesn't really matter that the names are the same. Each object in ODI is assigned a unique object ID and that is what is used when an import is performed to determine what action is taken in the target repsitory. As long as that ID doesn't match an ID that already exists in your target repository then you will be ok if using Synonym Insert, although I'd suggest using Synonym Insert/Update. Part of the object ID is based on the ID of the repository the object was exported from originally, therefore as long as you have unique repsitory IDs across your environments (basic good practice) then you shouldn't hit any significant issues.
Thanks a lot for quick response.