-
Staging and Operational Data Store
What are Staging and Operational Data Stores and what is their difference? Why does one need staging and why does one need ODS? What will happen if they are not there? Who and how is it decided that a staging or ODS is needed? Which comes first staging or ODS?
-
Calculate max value of a column
How to calculate max value of a column without using aggregrator transformation?
-
Oracle Snapshot too old error
What is Ora1555 error. Snapshot too Old error. Explain in detail.
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
-
Meta Data and Data Dictionary
What are the differences between Meta Data and Data Dictionary?
-
-
-
-
-
-
-
-
-
What is a staging area? Do we need it? What is the purpose of a staging area?
Answered by Laxmi on 2005-05-13 16:42:53: Staging area is place where you 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 , and perform data cleansing and merging , before loading the data into warehouse.