In ODI, How to use same mappings if source technology is changed from MS SQL Server to Oracle
Summary:
Hi Team,
We are having one situations where MS SQL Server database objects are replicated to Oracle database for one Schema and we are having mappings which are taking MS SQL Server as source and now requirement is same tables will be used but instead of taking MS SQL as Source, Oracle DB should also be taken as source with same ODI mappings as per ad-hoc requirement.(Basically source technology is changed)
As we do settings for environments of Context in Topology, we have checked but Logical Schema used for MS SQL source in context is not able to point to Physical schema of Oracle Technology.(Physical Schema of Oracle Technology are not coming in list of schema's of Logical Schema of MS SQL server as both are different technology)