This Question is not yet answered!

•   Olap and oltp
•   Improve report running performance
•   Olap and oltp
•   How to get the source from oltp systems to the staging area in real time
•   What are the steps involved in to get source from oltp system to staging area
•   What are steps invovlved in connecting oltp system to dataware house to get the souce from oltp system
•   Explain the flow of data starting with oltp to olap including staging ,summary tables,facts and dimensions.
•   What is e-r modelling and why is it used for oltp designwhat is dimesional modelling and why is it used for datawarehouse desgn
•   Summarize the differene between oltp,ods and data warehouse ?
•   1) differences between dss and oltp.2) explain grouped cross tab.3) define surrogate key.4) what is iqd file.5) expalin reference cursor.

•   Oltp hanging application
•   Does data warehouse have to be a relational database? Are data warehouse queries ‘unpredictable’? Why would data warehouse have ‘few concurrent users’? What is the maximum number of concurrent users,
•   What is oltp?