✍ Kashif M
Trends

Saturday, 11 March 2017


Data Warehouse Components


By on March 11, 2017

Typical Data Warehouse Components 
 
 



Data Warehouse Components
Data Warehouse Components

 

1. Source Systems

Source systems may be in the form of data existing in:

Production operational systems within an organization

Archives

Internal files not directly associated with company operational systems, such as individual spreadsheets and workbooks

External data from outside the company

2. Data Staging Area

The data staging area is analogous to a kitchen of a restaurant where raw food products are transformed into a fine meal. In a data warehouse, raw operational data is transformed into a warehouse deliverable analytical data fit for query and consumption.

It is both a storage area and a set of processes commonly known as Extract-Transformation-Load (ETL). It is off limits to business users and it is not suitable for querying and reporting. ETL is covered in detail later in the session. It may be an operational data store (ODS) environment, a set of flat files, a series of tables in a relational database server, or proprietary data structures used by data staging tools.

A normalized database for data staging area is acceptable.

Kashif
mkashu: Data Warehouse Components
Review : Kashif | Kashif
Update: March 11, 2017 | Rating: 4.5

Comment for "Data Warehouse Components"

0 comments

Post a Comment

Blog Archive