e-ISSN : 0975-3397
Print ISSN : 2229-5631
Home | About Us | Contact Us

ARTICLES IN PRESS

Articles in Press

ISSUES

Current Issue
Archives

CALL FOR PAPERS

CFP 2021

TOPICS

IJCSE Topics

EDITORIAL BOARD

Editors

Indexed in

oa
 

ABSTRACT

Title : Optimization of ETL Work Flow in Data Warehouse
Authors : Kommineni Sivaganesh, P Srinivasu, Dr Suresh Chandra Satapathy
Keywords : Extraction, Transformation, Loading, Conceptual Design, Logical Design, Optimization.
Issue Date : September 2012.
Abstract :
ETL is responsible for extracting the information or data from different several Areas and applies some cleaning, customization, transformation function for data and finally loading into the data warehouse. This paper presents , to implement the one ETL scenario with the help of ARKTOS II. It is a stepwise process, firstly to design the conceptual model for the ETL scenario it contains the quick documentation which contains their relationships, attributes and transformation among them. Next one is a formal logical model for the ETL scenario, it contains the flow of data from the sources towards the data warehouse through the transformations and data stores. ETL processes handle the large volume of data, and managing the workload. It is a complex task and expensive operations in terms of time and system resources. Therefore to minimize the time required for completion of ETL workflow and resources needed for the ETL tasks. So that we implement the optimization for the ETL workflows, in the minimizing the total cost of the ETL scenario.
Page(s) : 1579-1586
ISSN : 0975–3397
Source : Vol. 4, Issue.09

All Rights Reserved © 2009-2024 Engg Journals Publications
Page copy protected against web site content infringement by CopyscapeCreative Commons License