How to set up a trick called ‘put a file in a folder and it’ll dissappear in DWH’ with Oracle Data Integrator.
Imagine that we need to upload a text file in DWH whenever it appears in some folder with no defined schedule.
It really easy to do in ODI:
So we’ve got a scenario which grabs files from a folder and processes it. Just run it and it’ll wait in background and process all the files you throw at it. But what happens if we reboot ODI agent server? To ensure that this task starts automatically — just add a schedule for this scenario with ‘Start on Startup’ option.
Bingo: disaster-prone file vacuum cleaner )