Category Archives: ODI

Implementing Apache Drill in ODI 12C – Part 1

Implementing Apache Drill in ODI 12C – Part 1 Hello Friends, In the previous post I had explained how to use json file in odi mapping and loading the data […]

Json File Processing in ODI 12C

Json file processing in ODI 12C: Environment: Oracle Data Integrator Version 12.2.1 (Build ODI_12.2.1.2.6_GENERIC_161202.0826) Oracle XE 11g OS: Windows 8 This article will walk through the following steps to load […]

Transaction Isolation Level in ODI

Transaction Isolation Level in ODI: Hi Friends, Today I am going to demonstrate the Transaction Isolation in ODI. While working with temporary tables in SQL Server I got some surprising result […]

Review User Activity in ODI 12.2.1

Review User Activity in ODI 12.2.1: Today I am showing a new feature and probably something best for the admin guys. Its about the user statistics those are currently logged […]

Upgrading ODI 12.1.3 repositories to 12.2.1

Upgrading ODI 12.1.3 repositories to 12.2.1: This is a quick post on upgrading your existing repositories from 12.1.3 to 12.2.1. Make sure you have complete backup of master and work […]

Loading Hive to Oracle DB in ODI

Loading Hive to Oracle DB in ODI: In the previous article we tried to load  a local file to Hive table with combination of KMs. Also we saw that Data Direct […]

Exporting local file to hive table in ODI

Exporting local file to hive table in ODI: In this post we will discuss on loading a local file into hive using ODI inbuilt KMs. Before you start this I […]

Oracle Data Integrator 12c Implementation Essentials 1Z1-448

Oracle Data Integrator 12c Implementation Essentials 1Z1-448   Click here to know more on this   The Oracle Data Integrator 12c Implementation Essentials certification is available to all candidates but […]

Stepping into Big Data World with ODI Footprint, Part 1

Stepping into Big Data World with ODI Footprint, Part 1 This post is dedicated for those ODI lovers requesting me in my personal email id to have some post on […]

Yellow Interface (Temporary Interface) in ODI11g

Yellow Interface (Temporary Interface) in ODI11g: This is another quick post again based on some request. After the latest patch release of 12C, I am giving most of my leisure […]