This error occurs when you have multiple schemas but no default schema defined. Go to Topology – > Physical Architecture – > Technology – > Data Server . Edit the physical server that you want to be the default and … Continue reading
Monthly Archives: September 2009
September 6, 2009
by Cezar Santos
15 Comments
Categories: How to , ODI , Tips and Tricks
Tags: INTERFACES , ODI , ODI Experts , Oracle Data Integrator
How to create a Temp Table in ODI Interface (Yellow Interface)
Define the Interface Name , optimization context and select the proper schema for staging Area different from the Target In the Diagram Tab, Drag your source in to the Source side In the Target Data store Click on the Untitled … Continue reading
Printing report
In ODI , reports can be generated in Designer and Topology about Packages , Interfaces , Procedures ,Physical and Logical architecture and other option… Designer Right click on Folder and select print –> Interfaces , Procedures ,Packages and Folder … Continue reading
Step by step procedure to Read Excel (*.xls)
Sample of the Excel file to be populated in Oracle. 2. Set up the odbc connection to excel file through Control panel -> administrative tools – >Data source (odbc) (Windows ) 3. Use the JDBC – ODBC BRIDGE DRIVER in … Continue reading
September 1, 2009
by kdevendr
12 Comments
Categories: How to , Knowledge Modules , Logic , ODI
Tags: KM , Knowledge Modules
Importing Knowledge Modules
Go to Designer – > Project – > Knowledge Modules – > Import Knowledge Modules Go to File Import directory … orahome_1oraclediimpexp ( windows ) Select the Complete List or a particular Knowledge Module to be imported and will be … Continue reading