You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

In ODI, How to use same mappings if source technology is changed from MS SQL Server to Oracle

Accepted answer
21
Views
5
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!