Answers

Question and Answer:

  Home  Extract, transform, load (ETL)

⟩ Explain What is a staging area? Do we need it? What is the purpose of a staging area?

Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps:

Source data extraction, Data transformation (restructuring),

Data transformation (data cleansing, value transformations),

Surrogate key assignments

 163 views

More Questions for you: