ODI 12c Online Training

Search This Blog

Snowflake Schema Data Warehouse Concepts

March 28, 2013

Get link
Facebook
X
Pinterest
Email
Other Apps

Snowflake Schema Data Warehouse Concepts

DWH MODELING

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>

Unable to lock Central Inventory. OPatch will attempt to re-lock

Unable to lock Central Inventory. OPatch will attempt to re-lock OiiolLogger.addFileHandler:Error while adding file handler - C:\Program Files\Oracle\Inventory/logs\OPatch2015-06-18_12-24-59-PM.logjava.io.FileNotFoundException: C:\Program Files\Oracle\Inventory\logs\OPatch2015-06-18_12-24-59-PM.log (Access is denied)Unable to lock Central Inventory. OPatch will attempt to re-lock.Do you want to proceed? [y|n]Y (auto-answered by -silent)User Responded with: Y OPatch will sleep for few seconds, before re-trying to get the lock... It is an issue with privileges. Solution: ----------- In Windows: C:\Program Files\Oracle\Inventory\ContentsXML right click on directory=>properties=>Security=>select full control for your windows users. In Unix or Linux: /oracle/oraInventory/ContentsXML/ we need to grant 777 (read , write and execute privileges) to ContextsXML

Powered by Blogger

Snowflake Schema Data Warehouse Concepts

Comments

Post a Comment