ALLInterview.com :: Home Page Forum9.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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
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.
 
0
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
 
0
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
 
0
Anand
 
 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?  2
Can we take report on Excel in Business Objects? Oracle5
What is a universe? TCS5
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise? TCS1
what is the diff between etl tool and olap tool  2
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.  3
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?  1
what are cascading prompts explain with steps  3
who r the users in B.O.XIR2? PCS2
Is it possible to develop reports without Universe access? IBM4
how to overcome overflow of data in a report  5
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level Accenture1
What are the security level used in BO? Oracle2
why do we use crystal reports rather than webintelligence reports ? Tech-Mahindra2
how do u resolve contexts ? Wipro4
how to create a derived table in designer? i need steps regarding derived table  1
Difference between scope of analysis in webi and in deski? CA1
What is meant by ZABO and FC(full-client)?  2
What are the Errors in BO Pls Explain with Examples iFlex2
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?  3
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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