Answer Posted / sreekanth
Staging area is the place where data is tested for its
correctness , dta is cleaned before it goes to warehouse.
simple live example:
water filter.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is Cognos script editor?
Explain what is ods (operation data source)?
Explain er diagram?
How can we load the time dimension?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between olap and oltp?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are cluster analysis in data warehousing?
What is meta data and system catalog?
What a static and local variable?
Explain difference between view and materialized view?
What is the difference between metadata and data dictionary?
What are the different ways to represent the loading of dimension tables?
What are vaious etl tools in the market?
What are the possible data marts in retail sales?
