Using subqueries in Oracle Data Integrator (ODI) interfaces for complex data integration requirements

Uli Bethke Oracle Data Integrator (ODI)

Oracle Data Integrator does not have any built in functionality for subqueries in interfaces. This is one of the reasons why you will find people claiming that ODI has shortcomings when dealing with complex transformations. Shortcomings of existing workarounds In the ODI community various workarounds have been suggested to address this. The following discussion thread on OTN summarises these efforts. ...

ODI Snippets: OdiSqlUnload with header

Uli Bethke Oracle Data Integrator (ODI)

OdiSqlUnload is a handy tool to quickly dump the content of a table into a CSV file. This is a lot quicker than first creating a file data server, interfaces etc. However, OdiSqlUnload has one major drawback. It does not allow you to load the header columns of your table(s) into the CSV. This makes the tool pretty much useless ...

ODI snippets: Purge Log and shrink space

Uli Bethke Oracle, Oracle Data Integrator (ODI)

We all know that we should purge the ODI log on a regular basis. if we log everything or if we run near real time batches. You can either purge the log manually from the Operator module or you can use the ODIPurgeLog tool. As per Metalink 424663.1 the following tables contain information concerning Session runtime executions

When you ...

ODI Tutorials & Documentation: Oracle Data Integrator Resources for Beginners

Uli Bethke Oracle Data Integrator (ODI)

I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below. ODI Training. Learn ODI from the experts. In my opinion the best place to get started with is the Data Warehouse Best Practices using ...

Online resources that every ODI developer should know about Oracle Data Integrator!

Uli Bethke Oracle Data Integrator (ODI)

I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below. In my opinion the best place to get started with is the Data Warehouse Best Practices using Oracle Data Integrator Enterprise Edition guide. This ...