what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 6071 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 worklet?
How to delete data which is not in source table?
In Which Transformation We Can Use Having Clause In Informatica?
What are various etl tools in the market?
Identifying the bottlenecks in various components of Informatica and resolving them.
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What are the types of Data Warehouse applications?
How etl testing is different from database testing?
dimension object created in oracle can be imported in designer?how?
Compare ETL & Manual development?
What are the three tiers in etl?
What are the modules in Power Mart?
Explain me ETL project architecture in Detail?
can be used COM component in Informatica ?
What are the etl testing operations includes?
