Here is our scenario
We have custom interface process in place. Receiving file from third party ,upload data into staging tables, validate data, upload data into oracle interface tables, run Oracle interface to upload data into Oracle standard tables.
Whole process more or less is sequential. That means user have to process one file at a time. That is somewhat hindrance, users can't work in parallel or if anything goes wrong with one file user can't proceed to next.
What we are looking is for a solution where we accept multiple files at a time and process them simultaneously. Any suggestion how this can be achieved ?
Interface Suggestion
-
- Posts: 8
- Joined: Mon Dec 11, 2006 7:38 am
- Location: India
Hi,
One way, and it may not be the best, but its a suggestion...
Have mutliple concurrent process to validate the txt files. This would mean that multiple instatnces of the same validtauion scripts will read multiple files from the same location. As soon as the file is read move it to READ folder. The validation script needs to move to next file and read the next file.
One the file is sucessfully validated move to VALIDATED folder and now we know the chances of any error are minimal.
Regards.
One way, and it may not be the best, but its a suggestion...
Have mutliple concurrent process to validate the txt files. This would mean that multiple instatnces of the same validtauion scripts will read multiple files from the same location. As soon as the file is read move it to READ folder. The validation script needs to move to next file and read the next file.
One the file is sucessfully validated move to VALIDATED folder and now we know the chances of any error are minimal.
Regards.
-
- Posts: 19
- Joined: Sun May 07, 2006 7:16 am
- Location: India
Who is online
Users browsing this forum: No registered users and 3 guests