What is data staging?

Data Warehousing concept, Extract transform Load, ETL process

Data Warehousing concept, Extract transform Load, ETL process

 

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.

Related References

 

 

 

 

 

 

Advertisements