Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7317 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 data modeling and data mining?
Is hadoop a etl tool?
when will use SQL override in a lookup transformation?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
List few etl bugs?
Explain different types of partitioning?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is etl process? How many steps etl contains?
What is initial load and what is full load?
How can we use external procedural logic in informatica?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what happens if the info.server doesn't find the session parameter in the parameter file?
SCD2 will work on only dimension tables as well as fact Table?
what is the meaning of upgradation of Repository?
