Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7467 Views
- I also Faced
- E-Mail Answers
Answer Posted / kaki
OLTP
1. Normalized database; having lot of joins. Hence, slow
2. INSERT, UPDATE, DELETE immediately refelects data in the
OLTP transactional database.
OLAP
2. Denormalized database; having lesser joins. Hence,
performance is good.
3. Need a tool like ETL to populate the database; Data may
not be seen immediately after creation unless ETL populates
it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a staging area? What is the purpose of a staging area?
Explain do we need an etl tool?
what is the main role of FI on business
can cubes contain measures ?
What is lookup table in etl testing?
What is a mapping?
how do use session mapping parameters ?(in which transformation)
what is the use of server?
When do we go for the tools in the market?
What are snapshots?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
can be used COM component in Informatica ?
what are the production issues in datastage?
What is partitioning? Explain about round-robin, hash partitioning.
what is pmrep command?
