Data Integration involves Extract, Transform and Load data process. In Data Warehousing ETL is by far the complex tasks due quality issues if source data, Heterogeneous data sources etc. An ETL developer not only needs to know about the core concepts of ETL like handling SCD, best ways to capture change data (CDC) but also how to plan ETL tasks, data profiling, data quality checks.
Following books gives the good introductory details of ETL, best practices, core concepts of ETL.
[click to continue…]