Algorithm to load files efficiently without missing or accidently archiving....

view full story

http://www.unix.com – We have a requirement where we get the Delta Files in every one hour and we need to load them into Oracle database every one hour using Powercenter. To efficiently do this we need to build an File management system. Here is our process: we get 6 files for 6 tables with a timestamp appended .dat files (employee_021920121033.dat) along with these 6 files we get a .done (hr_021920121033.done) file indicating the 6 six files are ready to be loaded. Now we need to build a script that will identify that these files are ready to be loaded thereby move them to corresponding source direc (HowTos)