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 type 2 version dimension?
How many project sources we can create in metadata?
Is there any difference in testing database and data ware housing?
What are the different types of data warehousing?
What is difference between model & package?
Why should we use data ware housing and how can you extract data for analysis with example?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
How can we determine what records to extract?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is aggregate fact table?
How do you define data block size?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
