What is the primary purpose of a staging area in an ETL pipeline?
-
A
To permanently store transformed data
-
B
To serve as an intermediate holding zone for raw extracted data before transformation
-
C
To generate reports for end users
-
D
To replace the data warehouse entirely