Data Warehouse & ETL Tutorial
Data Warehouse & ETL Tutorial:
Data Warehouse is where data from different source systems are integrated, processed and stored. Data Warehouse data is a non-production data which is mainly used for analyzing and reporting purposes. Business users and higher management authorities use the data warehouse data to analyze, and to make important business decisions. Data Warehouse collects large volume of data from variant sources with many different data formats. The ETL(Extraction, Transformation and Loading) process handles these data and transforms it into a more consistent, standard formatted data. This ETL process is done with the help of an ETL tool and most widely used tools are Informatica, Data Stage, Ab Inito, Oracle Warehouse Builder etc.
This Data Warehouse and ETL tutorial section explains the data warehouse/ETL concepts, ETL tools and their usage with practical examples. Go through the links given below to read more.
Data Warehouse & ETL:
Database – RDBMS
ETL Tools: What to Learn?
ETL Tools – Informatica
Learn Informatica – Tutorial
Informatica – Transformations
ETL Tools – Transformation Manager
very Good explanation of all the concepts related to ETL and data modeling.