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 difference macros and prompts?
What is the use of dimensional modeling in data warehousing?
Explain the difference between filter and conditin?
What is a cube in data warehousing concept?
What is Cognos script editor?
Explain the data type of the surrogate key?
Store (and count) non-fact records?
Where the applications and where
Explain what is fact less fact table? Where you have used it in your project?
What is difference between e-r modeling and dimensional modeling?
What is execution plan?
What are the types of SCD?
Compare cold fusion with other programming languages?
What is the use of incremental aggregation? Explain me in brief with an example?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?