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
how much memory space occupied real time project (roughly)?
What is cost benefit analysis (cba)?
Explain what are the advantages data mining over traditional approaches?
What are the stages of datawarehousing?
What is cubes?
How can we run the graph? How can we schedule the graph in unix?
What are Aggregate tables?
What is the difference between a primary and secondary actor in use case modeling?
Explain conformed fact?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is difference macros and prompts?
Where we use surrogate key explain with example?
Explain about core dimension,
What is partitioning? What are the types of partitioning?
How to performance tune reports?
