Source Control is an Information technology environment management system for storing, tracking and managing changes to software. This is commonly done through a process of creating branches (copies for safely creating new features) off of the stable master version of the software, then merging stable feature branches back into the master version. This is also known as version control or revision control.
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?