ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Ordered SQL

Howdy, Friends…

A small but very useful tip!

There are some time we would need to process SQL (or load) via  a particular order and, to achieve that, many time the Developer would load the data into temporary tables and process them same later into Target.

We can change the way that joins are generated at Oracle Data Integrator (10g or 11g).

If we are dealing with latest Oracle database , there is option in ODI topology which when being enabled would enables us to do Ordered SQL and thus avoiding unnecessary temporary table and steps and even processing time.

To enable the Ordered SQL .

Go to Topology- > Physical Architecture – > Oracle Technology (or any technology you wish to change)

image

image

Interface

image

image

The option of the Ordered Join syntax is to be enabled and accordingly the order Number needs to specified.

ODI will process the joins based on the Order Number and also in the Ascending Order.

image

TABLE LENGTH

Just to add to the above technique , you can set the table length in the Technology settings.

image

Good to see you around… keep visiting us!

One Comment

  1. Can someone help How can we schedule the scenario Bi weekly in Load Plans and scenarios. Looking in ODI 12C version. Thanks for your help!

Leave a Reply

Required fields are marked *.