ENHANCE TO DATA CLENCHING FEATURES IN IBM DATA INTEGRATIONS SUITE

Abstract

Virtusa Corporation is a leading global technology innovation services provider and it has grown beyond being an efficient provider of product and application development services to being the partner of choice in creating competitive advantage for its clients using technology solutions. IBM Information Integration Solutions - Quality Stage team is one of the development teams in the Virtusa that goes under IBM Information Integration Solutions account. Prior to joining with the Virtusa this project was developed by the company Ascential software corporation. Now the maintenance part of the project is going on. Under this stage the aim of this project was to enhance data clenching features in the system IBM IIS - QualityStage Designer with the technology of VB6 Enterprise Edition. IBM IIS - QualityStage is a comprehensive development environment for building applications that re-engineer data. This data re-engineering environment is designed to help programmers, programmer analysts, business analysts, and others re-engineer data to,meet business objectives and data quality management standards. It provides a set of integrated modules for accomplishing data re-engineering tasks such as investigating, conditioning, matching, building relationships, resolving conflicts, and formatting data. The software development process used for this project was Rational Unified Process. Due to the maintenance part of the project is going on, the requirements of this project were mainly achieved through user feedbacks. Unified Modeling Language was used to convert the requirement into an analysis model. Then the analysis model was translated into a design model. To verify this system, logical system architecture diagram, design class diagram, high level use case diagram, component diagram, user interfaces and Entity-Relational diagram was created. An iterative approach was applied to each phase above to give the problem owner to be involved in the development of the system. Evaluative feedbacks were acquired through mails from problem owners. Refinements and Modifications were carried out after each meeting to meet the client’s requirements.