Explain what are the main important differences between olap and oltp?
Submitted by: Administratorolap:online analytical processing is that which describes procesing at warehouses.
oltp:online transactional processing is that which describes at the operational sites..
oltp olap
1.Mb-tb of data 1.gb-tb of data
2.mostly updates 2.mostly reads
3.many small transactions 3.summerized and consolidated data
4.raw data which is updated frequently 4.users are decision makers and analyts
5.consistency recoverability is critical
6.clerical users
Submitted by: Administrator
oltp:online transactional processing is that which describes at the operational sites..
oltp olap
1.Mb-tb of data 1.gb-tb of data
2.mostly updates 2.mostly reads
3.many small transactions 3.summerized and consolidated data
4.raw data which is updated frequently 4.users are decision makers and analyts
5.consistency recoverability is critical
6.clerical users
Submitted by: Administrator
Read Online Analysis Services Job Interview Questions And Answers
Top Analysis Services Questions
☺ | Explain the difference between analysis and synthesis? |
☺ | Explain two reasons why feeding data into OLAP system directly from the source operational system is not recommended? |
☺ | Give details of the various approaches of software evaluation? |
☺ | Tell me what are the tools used for data analysis in DHW especially where DataStage is being used as the ETL tool? |
☺ | Explain ATM Security level? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |