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
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain can report net connect multiple datasource at a time in report creation time?
Explain about core dimension, balanced dimension, and dirty dimension?
What are the data types present in bo? What happens if we implement view in the designer n report?
How can we load the time dimension?
What is a Decision Tree Algorithm?
What is vdl (view definition language) explain?
What is the difference between filter and lookup transformation?
What a static and local variable?
Explain ddl (data definition language)?
What are the data marts?
What is an er diagram?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is the extension of file to save template?
What are session timeout and application timeout?
