slides

Automation and control over ETL processes implementation in SAS system

Abstract

The process of data integration is used today in both commercial as well as in scientic fields. Implementations are comprised of many different ETL processes to achieve proper transformation of data. Automation and control of entire process is a crucial aspect for each solution. Thesis describes how ETL framework is used with implementation and which functionality are supported. We start by describing the data model, that is typically used in the business world. Followed by the Presentation of software used for framework development and defining different sets of ETL process flows. Next, we provide detailed presentation of ETL framework, which is afterwards compared with other solutions. We finalize the thesis by describing the ETL framework interaction from the user perspective, and by drawing conclusions

    Similar works