A renowned Insurance Provider uses the Oracle Insurance Policy Administration application (OIPA), which is widely acclaimed and very popular. The client primarily uses the Oracle database for storing transaction processing and running the application. However there is one problem, the Oracle database is of SCD Type I., which essentially means that it does not record historical data. Historical data helps in understanding key aspects of the business and cannot be ignored by this company.
The client approached Bilvantis to solve this pressing need. They asked us to build a data warehouse in real-time and record every transaction history. Bilvantis delivered the solution in record time using Informatica Power Exchange (PWX) in combination with Power Center (PC), and ETL tools.
