Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference btween olap and oltp?

Answer Posted / madhusudana rao

OLTP:
# OLTP means Online Transactional Processing, data comes
from different sources
# OLTP is normalized(3NF)
# it's used to stored the current transactional data
# it's store the less no of data
# here we will perform the DML operations
(INSERT,UPDATE,DELETE)
# performance is very fast

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2199


explain in detail about type 3?

1065


What is difference between custom hierarchy and report based hierarchy?

1054


How were the reports scheduled and how to resolve unexecuted documents?

2720


Can anybody tell me what are the tuning problems?

2082


What is the difference between user and versatile user?

1140


How we drill up week to month?

1112


What we need to discuss with designer before starting the universe designing.

2295


Did you face any problems while creating reports? Name? Solutions?

3737


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1090


Explain when to use local filter and when to use global filter?

1401


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1174


In banking domain how many Fact tables,Dimension table are present?

8850


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2085


What is Indexing? how did u implement indexing?

2555