Friday, 1 August 2014

Get Physical Schema name using odiref in ODI


Using below method we can get Database  SchemaName.

select *  from all_tables where
owner= '<%=odiRef.getSchemaName()%>'

Using below method we can get Database  SchemaName for Default Physical Schema from your Databaserver.

select *  from all_tables where
owner= '<%=odiRef.getSchemaNameDefaultPSchema()%>

1 comment: