Shri Dana

• Apr 6th, 2005

 

OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge storage of historical information obtained from different datamarts for making intelligent decisions about the organization.

sshravanam

 Profile Answers by sshravanam Questions by sshravanam

• Apr 3rd, 2007

 

OLTP systems will be having transactional data thats keep on changing,so it cant be taken for warehousing.

John Kaiser

• Jun 20th, 2007

 

The data warehouse obtains data from one or more source systems which could be OLTP systems. So it could happen that the OLTP system and the data warehouse contain the same data. What distinguishes the data warehouse from the OLTP system is the data organisation. The data warehouse organises its data for query, analysis and reporting.

1292033

• Aug 2nd, 2007

 

Because OLTP databases are transactional data related databases. The meaning of this is these databases are used in real time to insert, update and delete data. To accomplish these tasks in real time, The model used in OLTP databases is highly normalized. The problem of using this model in Data Warehousing is, we have to join multiple tables to get a single piece of data. With the amount of historical data we deal with in DW, it is highly desirable not to have a highly normalized data model like OLTP.

jyotsna

• Sep 6th, 2007

 

OLTP databases are generally volatile in nature which are not suitable for datawarehouses which we use to store historic data