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 are the different models used in cluster analysis?
What is recovering sessions?
Where the cache files stored?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain conformed fact?
I have two universes created by two difference database can we join them in designer & report level? How
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are vaious etl tools in the market?
What is surrogate key? Explain with examples.
Can you brief about the Data warehouse project you worked on?
Explain which columns go to the fact table and which columns go the dimension table?
What is data warehosuing hierarchy?
Compare cold fusion with other programming languages?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
what are the others of "bad files" and "discard files" when using sql*loader?
