ODI 12c Online Training

Search This Blog

Added Pivot , Unpivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

June 05, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

Added Pivot , Un pivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

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()%> '

BI Publisher error : Server not initialized. Please make sure the repository is ready

BI Publisher error : Server not initialized. Please make sure the repository is ready Solution: ---------- MW_HOME\user_projects\domains\bifoundation_domain\config\bipublisher Edit xmlp-server-config.xml file add below two lines and if already exists verify both repository path. <?xml version="1.0" encoding="UTF-8" standalone="no"?><xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp"> <resource> <file path="${xdo.server.config.dir}/repository"/> </resource> <config> <file path="${xdo.server.config.dir}/repository"/> </config> </xmlpConfig>

ODI 12c 12.1.3 Repository Tables : Master 67 tables & Work 153 tables total 220 tables.

Master repository Tables: 67 TNAME TABTYP ------------------------------ ------ SNP_ACTION TABLE SNP_AGENT TABLE SNP_AGENT_PROP TABLE SNP_AGENT_PROP_LST TABLE SNP_ALLOC_AGENT TABLE SNP_CONNECT TABLE SNP_CONNECT_PROP ...

Added Pivot , Unpivot ,Table functions and sub query objects in new ODI 12.1.2 patch number 17053768

Comments

Post a Comment