Category Archives: ODI

Protected: Varieties of Redshift copy and unload commands

There is no excerpt because this is a protected post.

Protected: Exploring Google BigQuery Python Client

There is no excerpt because this is a protected post.

Protected: Working with BigQuery complex datatype

There is no excerpt because this is a protected post.

Increase Scenario Internal id Sequence Using ODI SDK

Increase scenario internal id sequence using ODI SDK: In this post I will be demonstrating ODI SDK code that can be used to increase the internal id sequence in ODI 11g.  Now […]

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 […]