Incremental update in ODI

Incremental Update

  •  In this type of Integration before inserting data into target first we
    check data is Existing in target or not, if data is exist then we update
    otherwise we insert that data.

Real time Scenario

  • Consider there a two flat files join these
    files and populate the data into the target table , Use Oracle
    incremental update

Steps to Implement that scenario using Incremental update

  •  Create data server for file and target table
  • Create physical schema and logical schema
  •  Create data store for flat file and create a target table at the run time.
  •  Implement mapping, import appropriate knowledge module

One thought on “Incremental update in ODI

  1. Justin says:

    Hello mr.bhavesh, your tutorials are very helpful and inspiring at the same time. Thanks for this tutorials. I have a project for developmet stuff, pitch me your ,message if you do freelance work.

Leave a Reply

Your email address will not be published. Required fields are marked *