what is the difference between OLTP database and data
warehousing database?
Answer Posted / srinivas
OLTP(ONLINE TRANSACTION PROCESSING SYSTEM):
1. It is used for transaction processing.
2. tables and joins are complex.
3. entity relation models will use.
4. used for write operations.
5. performance is low.
OLAP(ONLINE ANALATYCIAL PROCESSING SYSTEM):
1. It is used for analytacial prcessing.
2. tables and joins are simple.
3. dimension modeling will use.
4. used only for read operations.
5. performance is high.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the key benefits of ETL Testing?
what is Forward,Reverse and Re_engineering?
Is hadoop a etl tool?
Explain about round-robi?
What is etl process?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what happens if the info.server doesn't find the session parameter in the parameter file?
Difference between flat files and relational sources?
can be used COM component in Informatica ?
Explain what is etl process? How many steps etl contains explain with example?
What are various etl tools in the market?
what is the difference between cardinality and Nullability?
what are the session parameters? How do u set them?
What is lookup table in etl testing?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ