ODI Knowledge Module frequently used Jhytons
Get target schema name: <%=odiRef.getSchemaName("D")%> Get target table name: <%=odiRef.getTargetTable("TABLE_NAME")%> sample code: drop synonym <%=odiRef.getSchemaName( "D" )%>.syn_<%=odiRef.getTargetTable( "TABLE_NAME" )%> output: drop synonym XXTG_HR_STG.syn_BEN_BENFTS_GRP further codes will be here in a while