How Does Extract Transform Load Help In Data Warehousing

Published in Journal

Journal of Advances in Science and Technology [JAST] (Vol:3/ Issue: 6) DOI: 10.29070/JAST
Authors: Sk Humayun,
Subjects: Science & Technology

Year: Aug, 2012
Volume: 3 / Issue: 6
Pages: 0 - 0 (0)
Publisher: Ignited Minds Journals
Source:
E-ISSN: 2230-9659
DOI:
Published URL: http://ipublisher.in/I/a/1352
Published On: Aug, 2012

Article Details

How Does Extract Transform Load Help In Data Warehousing |

Sk Humayun, in Journal of Advances in Science and Technology | Science & Technology

Download PDF

View PDF

ABSTRACT:

The data warehouse is the centralizedrepository which stores the data from multiple information sources and thentransforms it into the common and multidimensional data model for the efficientquerying and analysis. ETL is one of the tools that are used by data warehouseand ETL helps data to perform its operations flexible and consistent and alsomore efficient. ETL (Extraction, transformation, and loading) takes place inthe data warehouse, when the data warehouse is populated for first time andalso it takes place regularly at the time of updating the data warehouse. ETLtools provide more value to the data warehousing.