Why are OLTP database designs not generally a good idea for a Data Warehouse?
Since in OLTP,tables are normalised and hence query response will be slow for end user and OLTP doesnot contain years of data and hence cannot be analysed.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is OLTP? 08.12.08
In the transaction server, the client component usually includes GUI and the server components usually consists of SQL transactions against a database. These...Why are OLTP database designs not generally a good idea for a Data Warehouse ? 25.09.08
OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge storag...Summarize the differene between OLTP,ODS AND DATA WAREHOUSE ? 22.09.08
oltp - means online transaction processiing ,it is nothing but a database ,we are calling oracle,sqlserver,db2 are olap tools. OLTP databases, as the name im...What is the difference between ODS and Staging? 20.09.08
An operational data store (ODS) is a type of database often used as an interim area for a data warehouse. Unlike a data warehouse, which contains static data, t...What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports? 30.07.06
Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just...How is a data warehouse different from a normal database? 15.06.06
Every company conducting business inputs valuable information into transactional-oriented data stores. The distinguishing traits of these online transaction pro...What is OLTP? 22.03.06
In the transaction server, the client component usually includes GUI and the server components usually consists of SQL transactions against a database. These...Why should you put your data warehouse on a different system than your OLTP system? 17.03.06
A OLTP system is basically " data oriented " (ER model) and not " Subject oriented "(Dimensional Model) .That is why we design a separate system that will have...What is ETL? 17.03.06
ETL stands for extraction, transformation and loading. ETL provide developers with an interface for designing source-to-target mappings, ransformation and jo...What is the Difference between OLTP and OLAP? 17.03.06
Main Differences between OLTP and OLAP are:- 1. User and System Orientation OLTP: customer-oriented, used for data analysis and querying by clerks, client...