The Management of Conformed ETL Architecture

Abstract

This paper deals with the core research on the architecture of ETL process which is applied on BI environment along with the advent of metadata at each corresponding layer that can be applicable to all the scenarios of BI. The management of extraction process has been done using several operators which help in reducing its complexity. New operators have been developed to easily understand each and every layer of extraction process. ETL stands for extraction, transformation and loading, and it plays a vital role in the area of business intelligence. Extraction is the process of extracting heterogeneous data from disparate source system for further analysis in a data warehouse environment. Transformation is a process of storing data in a correct, unambiguous and consistent format which is compatible to the format of existing data warehouse. Loading is a process that loads data into the end target which may be simply a data warehouse or a data mart.