Page 81 - DCAP606_BUSINESS_INTELLIGENCE
P. 81
Business Intelligence
Notes Transforming it to fit operational needs, which can include quality levels
Loading it into the end target (database, more specifically, operational data store, data
mart or data warehouse)
Figure 5.5 shows a complete description of ETL Architecture Pattern.
Figure 5.5: ETL Architecture Pattern
Source: http://upload.wikimedia.org/wikipedia/commons/d/d8/ETL_Architecture_Pattern.jpg
Extract
The first stage of an ETL process involves extracting the data from the source systems. An
intrinsic part of the extraction involves the parsing of extracted data, resulting in a check if the
data meets an expected pattern or structure. If not, the data may be rejected entirely or in part.
76 LOVELY PROFESSIONAL UNIVERSITY
