Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is ETL Architecture?

Architecture

What is ETL Architecture?

by  ganotedp  Posted    (Edited  )
ETL architecture connects three areas: source, staging, and target. Sources are typically one or more OLTP systems. Staging is a common holding and work area. Targets are typically a data warehouse or mart.

"The source to stage component is intended to focus the efforts of reading the source data (sourcing) and replicating the data to the staging area."

"The stage to warehouse component focuses the effort of standardizing and centralizing the data from the source systems into a single view of the organizationÆs information. This centralized target can be a data warehouse, data mart, operational data store, customer list store, reporting database or any other reporting/data environment."

The Best Practice is "to consolidate the business rules into the stage to warehouse ETL component". This Best Practice can tie ETL architecture to EAI architecture.

Quotes are from Brad Crowley's article at http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=4072
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top