Is it possible to define more than one physical schema associated with the same data
server?
A.
Yes, but you have to flag which one is the default physical schema.
B.
Yes, but it is mandatory to specify a different user to log in.
C.
It is possible,but it is better to avoid doing so because it is more difficult to define a logical
schema this way.
D.
No, ODI Topology does not allow defining more than one physical schema for a data
server because the associated logical schema would be ambiguous.
Explanation:
A is the correct answer we can define two physical schema in one DB server in ODI by setting one default server
I agree. A.
https://gerardnico.com/doc/odi/webhelp/en/refmanual/topology/snppschema.htm
A is correct, tested