ODI 12c - Loading Files into Oracle, community post from ToadWorld
Posted
by David Allan
on Oracle Blogs
See other posts from Oracle Blogs
or by David Allan
Published on Wed, 4 Jun 2014 21:37:11 +0000
Indexed on
2014/06/05
9:35 UTC
Read the original article
Hit count: 471
/ODI Technical Feature Overviews
There's a complete soup to nuts post from Deepak Vohra on the Oracle community pages of ToadWorld on loading a fixed length file into the Oracle database. This post is interesting from a few fronts; firstly this is the out of the box experience, no specialized KMs so just basic integration from getting the software installed to running a mapping. Also it demonstrates fixed length file integration including how to use the ODI UI to define the fields and pertinent properties.
Check the blog post out below....
Hopefully you also find this useful, many thanks to Deepak for sharing his experiences. You could take this example further and illustrate how to load into Oracle using the LKM File to Oracle via External table knowledge module which will perform much better and also leverage such things as using wildcards for loading many files into the 12c database.
© Oracle Blogs or respective owner