How to handle Early Arriving Facts and Late Dimension in ODI

Hi All, I read an article in the Oracle Blogs about implementing the early arriving facts or late dimensions and this is a re creation of t...

Read More

Early Arriving Facts or Late Arriving Dimensions

Early Arriving Fact  Also known as Late Arriving Dimensions. An early arriving fact takes place when the activity measurement arrives at...

Read More

How to Implement CDC in ODI 11g

Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integr...

Read More

Change Data Capture in ODI

Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integr...

Read More

ODI - Using ODI user function with Interface or Package

Hi, It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created...

Read More

ODI- NATIVE SEQUENCE Generator

Hi , For using Native Sequence generation in ODI interface, you can follow the below steps. CREATE TARGET TABLE CREATE TABLE "...

Read More

ODI- Slowly Changing Dimension [SCD TYPE 2]

The below steps shows how SCD 2 is configured in ODI 11g Pre requisites : ODI installed and configured with Topology for source and...

Read More