Data staging is focused on data capture, performing data cleansing, and transformation from the data sources (e.g. database, ERP, Input files, etc.) into a landing database and/or schema for storage and follow on processing. The ETL data staging process, also, perform post load table/index optimization, if applicable for the database and load strategy.
- What are ETL Reconciliation Jobs
- ETL Error Handling Effective Practices
- What Is data Transformation?