Blog

ODI Interview Questions

ODI interview questions: 1. What is Oracle Data Integrator ? 2. Can we call ODI as a ETL tool. If yes then How ? 3. Is it a ELT tool? […]

Router Transformation in ODI

Router Transformation in ODI: Hi Guys!!!! Here is the post you were looking for. I had to spare few time  as I was getting so many emails on this. You […]

Send mail in ODI using Gmail Credentials

Send mail in ODI using Gmail Credentials: Are you facing problem in sending mail from ODI ??? Don’t you have any dedicated mail host ?? Are you getting bunch of […]

Transaction Control in ODI

Transaction Control in ODI: Hii Guys!!! Today we will be discussing on  how a transaction can be controlled in ODI. Many people specially beginners, always get confused with rollback/commit feature […]

SCD Type3 in ODI

SCD Type3 in ODI: Today we will discuss SCD Type3 in ODI. Before moving to ODI we need to understand what is SCD Type3. In Type 3 Slowly Changing Dimension, […]

SCD Type2 in ODI

SCD Type2 in ODI: Hi folks!! Today we will discuss about SCD Type 2 implementation in ODI. So lets get started. ODI Version: 11.1.1.6 OS: Windows 7 Create source table: […]

IKM Oracle Multitable Insert with Filters

IKM Oracle Multitable Insert with Filters: Today we are going use IKM Oracle Multitable Insert with filters. This is normally used to load data from one source to multiple target […]

Rename All Files in a Directory

Rename All Files in a Directory: This code is tested in Windows OS.  Do the necessary changes as per your requirement. import java.io.File; class renameFiles{ public static void main(String args[]){ […]

How to use encoded password in ODI SDK

How to use encoded password in ODI SDK: Today I am going to share very interesting thing 😀 . I was struggling a lot to get the work around on […]

ODI 11.1.1.6 Installation on Windows Server 2008 64 bit

ODI 11.1.1.6 Installation on Windows Server 2008 64 bit: Today we will install ODI 11.1.1.6 on windows server 2008, 64 bit. So lets start it. Go to this location to […]