what is the difference between OLTP database and data
warehousing database?
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 the difference between cardinality and Nullability?
What is staging area referring to?
what is the main role of FI on business
Explain etl?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what make u disappointmnets in u r career
Explain what is etl process? How many steps etl contains explain with example?
what are the reports developed in sap bw project and what is the requirement for developing it?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is the difference steps for data modeling?
Explain the use lookup tables and Aggregate tables?
When do we analyze the tables?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is etl process?