[attachment=14319]
SYSTEM ANALYSIS
2.1 DEFINATION OF PROBLEM
EXISTING SYSTEM
In the existing System, the data existing is all the databases is consolidated manually, and the report is generated from the data of each database and the data is taken in to Excel Work Sheet and consolidated and finally the data is loaded into Oracle database manually by an operator.
PROPOSED SYSTEM
This System Extracts data from different databases using uniform interface/procedure and then transforms the extracted data into destination database suitable format and finally loads that data into the destination database. In this process of Extracting -------> Transforming -------> Loading, this system facilitates an ease of use of the functionality proposed to the user through Graphical User Interface and Wizard like Interface.
2.2 INTRODUCTION
2.2.1 OBJECTIVES OF THE SYSTEM
ETL (Extraction Transformer and Loader) System allows user to pick up a branch and proceed to perform Extraction, Transformation, Loading operations chosed branch asks for the required details to connect to the corresponding database.
System presents data extracted from the database to user and confirm with user weather transformation required. If required data is transformed and loaded into predefined database. After loading the data, it can be viewed and then can be connected are rolled back depending upon the situation.