ODI PACKAGES

Creating a new Package

To create a new Package:

In the Project tree in Designer Navigator, click the Packages node in the folder where you want to create the Package.

Right-click and select New Package. 

Type in the Name of the Package.

Go to the Diagram tab. 
Add steps as described in Working with Steps

From the File menu, click Save.

Package steps

The Package is the largest unit of execution in Oracle Data Integrator. A Package is made up of a sequence of steps organized into an execution diagram.

Each step can either succeed or fail its execution. Depending on the execution result (success or failure), a step can branch to another step.


Package Steps:

MONDAY, 9 MAY 2011

Duplicate Multiple Objects in a Package

Dear Guru's


Let me share one good feature of ODI11g.


We can duplicate more than one step in a package at a time.


Consider the following package having six steps.




I am going to duplicate 3steps at a time.

Select the required 3 steps using mouse or ctrl key.
In this case i selected the steps GetTheFileName,PopTrgWithThisFileName and checkForMoreFiles.

Then go to the icon task bar tab and click on the icon 'duplicate step'


Then it will duplicate the selected steps.


The above figure illustrates the results

In this way we can duplicate any number of steps in a package easily and quickly.




Thanks Guru's
Ram Kumar Lanke

FRIDAY, 6 MAY 2011

MULTIPLE SOURCE FILES-MULTIPLE TARGET TABLES-SINGLE INTERFACE

Hi Guru’s,

We have seen in the last post how to load multiple source files of same structure into a single table.

you can refer it by clicking here

Suppose if we want to load multiple source files into multiple target tables.

Then please just follow the same procedure which I explained in the previous post and do a little change to the target data store.

Open the source data store which is participating of the interface and replace the resource name with #Project_Name.FILE_NAME


Note : Project_Name means your project name

That’s it .


Thanks Guru's
Ram Kumar Lanke

www.odiguru.com