what does staging area of data warehouse have there and what purpose of it?
Posted on 2011-03-06
1. if we use staging area between ODS and EDW when perform ETL , what should be in staging area:
i) a copy of source tables ,so the transformation is performing between staging area and EDW
ii) a copy of target tables , so the transformation is performing between ODS and staging area
iii) a copy of source tables and a copy of target tables ,the transformation is performing at stage area
2.can the staging area be in the same source (ODS) database or in the EDW datawarehouse or it is in different database?