Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pratap gangula
Staging Area disconnects the data from Real time OLTP applications. Since OLTP systems are burdened with transactions, to avoid the OLTP slow downs during processing it is important that we mirror image the OLTP database before we start data transformations(Cleaning & Conforming) for warehouse.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between view materialized view and view?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is real-time datawarehousing?
Explain what is the metadata extension?
What do you mean by static and local variable?
Explain about core dimension, balanced dimension, and dirty dimension?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain me what is vldb?
What are the different types of segments?
What is analytical or analytic mean?
Explain the importance of data warehouse?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are snapshots? What are materialized views & where do we use them?
What is surrogate key? Where we use it?
Explain hybrid slowly changing dimension?
