Schema Modeler .Net Mappings

Data Abstract
1

if I change a physical table field name like BANKCODE to BANK_CODE in either the Schema Table Field or the SQL Alias
shouldn’t it show up in the result set with the schema table name or the aliased name?

Thanks,
Monte

2

Hello.
I’m not sure that I clearly understood your question. The result set on Preview tab will show database table field names, or alias names if they are indicated.

3

Ekaterina,

Any chance of getting the ODP12c.Net Oracle driver working in the schema modeler like the 10g version does? As far as the fields go, I think Anton’s suggestion works for this issue as well. I’m using a SQL statement with aliases and it was having a problem with the existence of a field with the same name in two tables so I’ve moved it to a sub-query and the field aliasing carries forward to the outer select. So that was a handy 2-for-1 solution.

Thanks,
Monte

4

Hello.
Ok, I’ll log an issue to add ODP12c.Net Oracle driver support.

5

Thanks, logged as bugs://72618

6

bugs://72618 got closed with status fixed.

7

How do I access the fix?

Thanks,
Monte