what is the difference between OLTP database and data
warehousing database?
Answer Posted / ankit kansal
OLTP systems are designed to handle events (Inserts,Update,Delete) frequently so its better to keep your database more normalized form as selection is not as frequent where as in case of
OLAP systems are designed purely for analysis or to find out trends using historical data so, to achieve this kind of functionality a data warehouse are designed more de-normalized where query(selection) is much faster.
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Explain the difference between etl tool and olap tools?
When do we analyze the tables?
What are the etl testing operations includes?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
dimension object created in oracle can be imported in designer?how?
What are cubes and olap cubes?
Explain about the data integration suite features?
What is etl process. How many steps etl contains explain with example?
what are the concerns of OLTP and DSS systems?
what is the meaning of upgradation of Repository?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Define Dynamic push down optmization?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is the meant by Normalization and de-normalization?