ETL Architecture Explaination

 

·         ETL Architecture

•  ETL is Extract Transformation and Load

•  Extracting the data from the OLTP environment and transforming the data into the ETL tools and    Loading the data into the OLAP environment

• OLTP can have multiple data sources called flat files and Databases and also legacy systems like DB2, mainframe databases

•  ETL will have a Source area and staging area and Landing area

• The source will be OLTP Db or else files

• The stage will be any of the RDBMS databases

• Target will be a database ( RDBMS)

• OLAP target will be designed like fact table and dimension table types and created as snowflake or star schema design.

OLAP Vs OLTP

OLTP

1. OLTP is a data source it can be a flat file or database 

2. It contains normalized data and current year data 

3. It contains regular transaction data 

OLAP 

• OLAP  will contain historical data and it must be a database 

• IT contains denormalized data and a huge volume of data 

• BI – reports will run on OLAP environment 

• OLAP will be a data source of an ETL process