Hello, I am working on project to create a data warehouse, so I need help with this assignment. Write a minimum of 3 pages on the process of moving the data you will be using in your Data Warehouse...

Running Header: Data Warehouse Processes 1
Data Warehouse Processes
Submitted By
Course
Professor
Date
Data Warehouse Processes 2
Introduction
The Data Warehousing technique can be defined as the approach of dividing data that is
particularly intended for appropriated data warehousing environment. It is a coordinated and
unified archive that offers high capacities for analyzing as well as to control data. In the data
distribution center the information is composed by the multidimensional model, which
incorporates actualities and measurements. It can be numeric or accurate data that mainly
epresent business or process action and each measurement represent various perspective for data
analysis. It is business activity to load data warehouse with new data. Normal life cycle of data
warehouse includes three main steps - Extraction, Transformation, and Loading (ETL). The
process of data warehouse can store large volume of data from different distinctive operational
sources. The information that is stored in a DW can go from approximately many Gigabytes to
many Terabytes. There are two challenges in this scenario. The first is identified with the data
storage capacity, which requires a substantial and exceedingly accessible storage framework.
The second concerns accessing as well as handling the information in due time, as the objective
is to give low response times for that queries which are used by users. (Almeida, R., Vieira, J.,
Vieira, M., 2012).
Processes used to Move Data
As organizations developed more perplexing and complex, corporation spread steadily. The
operational PC frameworks provided data to run everyday operations, except what the
administrators required were unique data that could be promptly used for making strategic
decisions. The operational frameworks, is vital as they were not ready to give vital data.
(Rastogi, A., K., 2014). During moving data to data warehouse by using ETL processes, the
Data Warehouse Processes 3
equired data is differentiated from OLTP database and then it is moved to data warehouse
database. ETL process is used for the modification of data.
Extraction – It is the first step in moving data. This is the step by which we extract data from
OLTP database. Every data has different attributes that should be overseen keeping in mind the
end goal to successfully extricate information for the ETL procedure. The procedure needs to
adequately coordinate frameworks that have various stages like unique database system, different
OS as well as all have different communication protocols. During extricating information from
various information sources, the ETL...