A Tutorial in ODI to load data from multiple files in a table. File details are saved in a Audit table, loop for each file to load data in DataBase. Project Files : https://github.com/maindolaamit/tutorials/tree/master/odi/file_project
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.