ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Faster and Easiest way to design Interfaces

Define your Model Folder and Models .

Right Click on the Target Models and select ‘Interface In

Image

Select your Generation Folder and Optimization Context accordingly and Select the Data Store Name for which the interfaces needs to be generated else Click ok and all the Interfaces will be generated at selected Folder.

Image

The sample Interfaces are generated as shown below according to the desired Data store Name.

Image

Drag in your source and apply the LKM , IKM and CKM and run the interface. Now there is simple process to make the selection of the KMs automatically.

Considering for an Example –

Source – SQL Server and Target – Oracle , LKM as SQL to Oracle , IKM SQL Control Append with No Flow control and Truncate as yes for options and No CKM as Flow control is disabled in IKM.

Open your LKM – LKM Sql to Oracle – Check mark the option Default KM for this pair of Technologies.

Image

Do the same for IKM SQL Control Append

Image

Go to IKM options and change the required settting

Image

[ Note : Please do not change it on the standard IKM , either make a duplicate and do the required changes or add change history with the required changes on both the conditions. This are some of the good practice of ODI KMs usage and Reusability ]

Image

Go the CKM Oracle and SQL and uncheck the mart – ” Default KM for this pair of Technologies ” as CKM wont be used since we are disabling the flow control option.

Image

Now drag your source and automatically your LKM , IKM and CKM will be selected. If not check with other option KMs , if they are overriding the above mentioned option of “Default KM for this pair of Technologies” .

Keep looking at ‘www.odiexperts.com ‘ for more wonderful tips and tricks.

Leave a Reply

Required fields are marked *.