O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Processing complex files with ODI

A new and highly underutilized feature introduced in ODI 11.1.1.5.0 was the ability to leverage complex files such as a source and target for integrations. Previously, ODI could handle many different types of files out of the box, such as delimited, fixed length, XML, and many other variations. But how would you handle a flat file sent from a vendor that has multiple record formats within the same file? The file could have many different types of delimiters as well as record formats. For example, the following line of a file has many different delimiters as well as objects within the line:

123456,^Joeseph Kraichely^15th Street,1923,Soulard,63104,US, MO, 314-555-1212

This row contains a person record, person is a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required