Do you know what are OLAP and OLTP?
Submitted by: AdministratorOLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data. Typical example of a transaction is commonly observed in Banks, Air tickets etc. Because OLTP uses client server architecture, it supports transactions to run cross a network.
OLAP: Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data coming from different sources (multi dimensional).
Submitted by: Administrator
OLAP: Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data coming from different sources (multi dimensional).
Submitted by: Administrator
Read Online MS SQL Data Mining Job Interview Questions And Answers
Top MS SQL Data Mining Questions
☺ | Explain what are different stages of “Data mining”? |
☺ | Explain what is Discrete and Continuous data in Data mining world? |
☺ | Can you explain what is MODEL in Data mining world? |
☺ | Tell me what are CUBES? |
☺ | Do you know how does the data mining and data warehousing work together? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |