ODI with GIT

ODI 12.2 introduced the use of Subversion as an integrated VCS tool within ODI. To setup GIT access in ODI go to the team menu use ‘Switch Versioning Application’ to select GIT then in the ‘Settings’ create connection Avoid selecting the Auto Version option checkbox. Selecting this feature will commit and push a new version…

ODI Product Management

latest product information at http://my.oracle.com/site/pd/fmw/products/di/odi/index.html   11.1.1.9 12.2.1 What’s New Link Link Certifications Link Link Product Docs Link Link License Docs Link Link Release Notes Link Link Training & Webcasts Link Link Sell ODI-EE with other Oracle products With GoldenGate With SOA Suite With Enterprise Data Quality With BIEE Suite, BI Apps, and Hyperion Apps With…

Performance Tuning Tricks Oracle Olap Cubes

Check if the available memory parameters for the DB SGA target are set high enough – this should be set at 35% of all RAM available to the db. OLAP_PAGE_POOL_SIZE should be set to 0 so that auto dynamic page pool is on and is managed by the database (will be set to 50% of PGA…

KILL Session Marked for Killed Forever

Do you have a session that you have killed, but it seems not to go away ? You issued this several times and it seems it still is marked for killed, but has a lock on the existing table. In order to determine which process ID to kill: a) On Unix: b) On Windows: Then…

Oracle OLAP Dimensions And Cubes

Oracle 8i Enterprise Edition came with a database feature known as dimensions, which were an additional layer of metadata you could put over a table or set of tables, to define hierarchical relationships between columns. For example, you could say that one column, ‘COUNTRY’, was the parent of another column ‘REGION’, which itself was the parent…

Install ODI 12c on Non-GUI Platforms

Prerequisites Download Oracle Data Integrator 12.1.3.0.0 installer and save & unzip. If you want to install ODI JEE agent or Collocated Agent then you also need to download Oracle Fusion Middleware Infrastructure. Open a command prompt and go to the directory where you unzipped the jars. JDK 1.7 is required for ODI 12.1.3. to verify run: java -version. Install Invoke…

ODI 12c new flow-based mappings

Oracle Data Integrator 12c introduces several new tools aimed at increasing developer productivity, improving data loading performance, and enabling closer integration with Oracle Fusion Middleware. Probably the most exciting of these new tools, particularly for users of Oracle Database’s Oracle Warehouse Builder feature who are looking to upgrade to Oracle Data Integrator, is the new “flow-based”…