Hi,
Does the multi-source model supports the translators of different type (considering that schema name and table name in both sources is the same ). Something like this for example:
<vdb name="vdbname" version="1">
<model visible="true" type="PHYSICAL" name="Customers" path="/Test/Customers.xmi">
<property name="supports-multi-source-bindings" value="true"/>
<source name="chicago" translator-name="oracle" connection-jndi-name="chicago-customers"/>
<source name="newyork" translator-name="h2" connection-jndi-name="newyork-customers"/>
</model>
</vdb>
It does, but there may be issues if the source query requires us to consider native type or other db specific information since the metadata is only obtained for a single source.
Steve