Answer Posted / sandeep.t nizamabad
THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
1.OLTP SYSTEMS
2.STAGING LAYER
3 DATA WAREHOUSE
4.DATA MARTS
5.REPORTS
6.BUSINESS USERS
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are diagrams?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How to create different types of templates?
Where we use surrogate key explain with example?
What are the data types present in bo?
Explain what does level of granularity of a fact table signify?
How can we do data cleaning?
Explain what are necessary tasks to install reportnet software?
Explain what is data validation strategies for data mart validation after loading process?
What is recovering sessions?
Explain what is partitioning? What are the types of partitioning?
Why should we use data ware housing and how can you extract data for analysis with example?
What is data type of the surrogate key?
Is there any rownum object from which we can do this?