ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the difference btween olap and oltp?
 Question Submitted By :: Sreedhar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference btween olap and oltp?
Answer
# 1
OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed. 

OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.
 
Is This Answer Correct ?    9 Yes 1 No
Jansi
 
  Re: what is the difference btween olap and oltp?
Answer
# 2
i am agree with the above answer.olap is denormalized and
oltp normalised
 
Is This Answer Correct ?    11 Yes 1 No
Vams_gk
 
 
 
  Re: what is the difference btween olap and oltp?
Answer
# 3
OLTP 
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data 
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high

OLAP
* It is the Dimensional Modeling
* It contains Denormalised  tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP
 
Is This Answer Correct ?    15 Yes 0 No
Anand
 
  Re: what is the difference btween olap and oltp?
Answer
# 4
OLTP 
 
•	Current data 
•	Short database transactions 
•	Online update/insert/delete 
•	Normalization is promoted 
•	High volume transactions 
•	Transaction recovery is necessary 
•	 only one record is processed at a time
•	data is present in 2d format
 
OLAP 
•	
•	Current and historical data
•	Long database transactions 
•	Batch update/insert/delete 
•	Denormalization is promoted 
•	Low volume transactions 
•	Transaction recovery is not necessary
•	group of records processed at a time
•	data is present in multi dim format
 
Is This Answer Correct ?    3 Yes 0 No
Balaji
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
What are the general issues in migration process?  3
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example IBM1
What is the use of BO SDK?  4
can i link two Universes having with different connection  3
Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project? TCS2
what is a Micro cube? TCS2
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?  2
how did u give developed universe to ur client?  1
What are the security level used in BO? Oracle2
What are the types of errors you faced while creating a report from two different data providers IBM1
can any body tell me how to create Hyperlinks in BO XI R2?  2
what is fantrap ? Tech-Mahindra3
How to create universe in business objects enterprise 11.5  1
How do you restrict access to rows of a database?  1
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....  1
how to make a report avilable to other users?  1
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?  3
How can we improve performance?  2
How do u Receive requiremnts from the client?  2
can anybody tell me about issues faced while creating reports Accenture1
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com