TITLE
COMPARISON OF ETL EXECUTION SPEEDS WHEN USING SQL CODE AND WHEN USING SSIS BUILT IN COMPONENTS
AUTHOR(S)
Slaviša Vučetić, Slaviša Ilić, Slavica Savić, Siniša Ilić
ABSTRACT
In this paper, we compare the execution speed of the ETL (Extract, Transform and Load) process, when it is implemented using SQL language code in the first case, and when it is implemented using the ETL tool SSIS (SQL Server Integration Services) in the second case. In the first case we present an example of how to extract data and perform certain transformations to data from tables of the source database by direct executing SQL code, and load the transformed data into a destination database. In the second case, we extract and transform the same data, but using the built in components of the SSIS ETL tool without the need to write any command. The main goal of the paper is to compare the execution speeds for running ETL job in both ways, and to obtain the order of magnitude of time needed to transfer and transform data from OLTP source to OLAP destination systems.
DOI
www.doi.org/10.70456/QMXD2316
PAGES
120-126
DOWNLOAD
https://unitechsp.tugab.bg/images/2023/1-EE/s1_p9_v6.pdf
How to cite this article:
Slaviša Vučetić, Slaviša Ilić, Slavica Savić, Siniša Ilić, COMPARISON OF ETL EXECUTION SPEEDS WHEN USING SQL CODE AND WHEN USING SSIS BUILT IN COMPONENTS, UNITECH – SELECTED PAPERS - 2024, 120-126