Technology
AS/400, COBOL/400, CL/400
|
Solution
The whole process was first divided into 3 high level components.
Extraction: Data extraction using stored procedures.
Transformation: Transforming extracted data into AS/400 system using preprocessor.
Loading: Posting into Policy Management database after validations.
The data was first reformatted using the application data structures. This became the input for preprocessor which was further divided into pre edit and edit processes. The pre edit brought reformatted data which existed in flat files to WINS mirrored database file structures known as hold files. Then pre edit performed high level policy validations. The edit process took the hold files as the input and posted them to the application master files after field level validations.
This solution helped the client to easily maintain its system as well as keep the room for further enhancements .
|
| |
|
 |
 |
Project Description
The client had a web based system, with XML based front end interface for Policy Cycle and back end as SQL Server. The client wanted to import data from SQL Server (Windows Environment) to AS/400 database.
|
 |
| |

|
|
| |
Major Issues / Challenges
A careful, generic and modular approach had to be used as the same process had to be run for multiple policy records, multiple data set levels, multiple endorsements and multiple lines of business.
|
|
| |
|
|
|
|