What is a staging area? Why we need it? What is the purpose of a
staging area?
Staging area is place where we the hold temporary tables on data
warehouse server.
Staging tables are connected to work area or fact tables.
We basically need staging area to hold the data for
cleansing(removing spaces/nulls or to provide expected date format etc.)
and merging purpose, before loading the data into data
warehouse/data mart.
No comments:
Post a Comment