Database - ETL process in Data
warehousing - Dec 01, 2008, 17:00 pm by Nishant Kumar
Explain the ETL process in Data warehousing.
Extraction, Transformation and
loading are different stages in data warehousing.
Extraction
In this phase, data is extracted from the source and loaded in a structure of
data warehouse.
Transformation
After extraction cleaning process happens for better analysis of data.
Loading
After cleaning, data is loaded in the structure of data
warehousing.
Database - ETL
process in Data warehousing - Jan 08, 2010, 15:55 pm by Vidya
Sagar
Explain the ETL process in Data warehousing.
ETL is an important component in data warehousing architecture. The data from
operational applications are copied into data warehouse staging area, from data
warehouse staging area into data warehouse. Ultimately the from the data
warehouse will be placed into a set of confirmed data marts that are accessible
by data marts.
The extraction of data, transforms values of inconsistent data, cleansing bad
data, filtering data and loading the data into the destination database is the
process ETL software performs. If a failure occurs by one ETL job, the
remaining ETL jobs must respond appropriately.
|
