|
|
 NEW INTERVIEW QUESTIONS.COM 
 DATA WAREHOUSING INTERVIEW QUESTIONS
GENERAL DATAWAREHOUSING INTERVIEW QUESTIONS  DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
 Question |
What is the Difference between OLTP and OLAP? |
 Answer
|
Main Differences between OLTP and OLAP are:-
1.User and System Orientation
OLTP: Customer-oriented, used for data analysis and querying by clerks, clients and IT professionals.
OLAP: Market-oriented, used for data analysis by knowledge workers( managers, executives, analysis).
2. Data Contents
OLTP: Manages current data, very detail-oriented.
OLAP: Manages large amounts of historical data, provides facilities for summarization and aggregation, stores information at different levels of granularity to support decision making process.
3. Database Design
OLTP: Adopts an entity relationship(ER) model and an application-oriented database design.
OLAP: Adopts star, snowflake or fact constellation model and a subject-oriented database design.
4. View
OLTP: Focuses on the current data within an enterprise or department.
OLAP: Spans multiple versions of a database schema due to the evolutionary process of an organization; integrates information from many organizational locations and data stores
Submitted By: ( puppy1974 @ hotmail . com )
© NewInterviewQuestions.com
|
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
| Notify me when better answer is posted! |
A D V E R T I S E M E N T
|
|
|
Latest 10 Answers
|
|
ABAP is basic (technical) side of SAP. which helps other function of business sibe ex.financial,sales,inventory& human resource.
|
|
Cluster index work as a primary key and as we know in a single table only one primary key should be there....Hence only one records can take cluster index.
|
|
Select Employee.*, Department.* from Employee LEFT OUTER JOIN Department ON Employee.EmpId=Department.DeptId
|
|
Both are the connection object but SQLCLIENT using while connect with Sqlserver database and OLEDB using while connect with MS-access database and Oracle database.
|
|
Only 1 cluster index and 255 non cluster index.
|
|
Because it's used to read the data from the DB as Read-only manner, only forward direction not backward..hence its not supporting edit operation.
|
|
I will throw my wife because if my wife dies ican get another but mother is only one I cannot get another
|
|
When mistake is found by compiler is known as ERROR , when a mistake is found by tester while testing is a BUG and when mistake is found by the end user it is known as DEFECT.
|
|
Create customer code & transporter code, create sales order, checke the payment received then released order from Finance, delivery, billing, invoice.
|
|
Invoice is a request sent by vendor for the payment against services/goods with all the necessary details like - Price, Rate, Quantity, Vendor Name, Vendor Address, Unique Invoice Number (From Vendor), Terms & Conditions.
|
|
Rating
(4.6) By 8 users
Added
Views
Rate it!