1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the differences between oltp and olap?

Question Posted / mayank solanki


What are the differences between oltp and olap?..

Answer / Kunal Jyoti

OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two main types of database systems, each designed for different purposes:
1. OLTP: OLTP systems are optimized for handling multiple short transactions with high concurrency, such as managing financial transactions or inventory management. They focus on data integrity and fast transaction processing.
2. OLAP: OLAP systems are optimized for complex queries and analysis of large datasets, such as sales reports or market trends. They use multidimensional modeling, aggregation, and drill-down/drill-up capabilities.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How to Create a folder using pmrep command?

1 Answers  

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

What are the different types of schemas?

11 Answers   ITC Infotech,

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1 Answers  

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

How do you manage the Parameter files while migrating your data from one environment to another environment?

1 Answers  

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

For more Informatica Interview Questions Click Here
Categories