Categories

Archive

What is an olap and oltp?

0

What is an OLAP (Online Analytical processing)  and OLTP (Online transactional processing): IT systems are generally divided in to two types OLAP and OLTP. While OLAP are more analytical while OLTP are more transactional.  OLTP acts as source to data Read more ›

Categories

What is ETL – Extraction, Transformation and Loading

0

Data warehousing needs single, consistent and complete data store for operational systems. This task to convert operational data to data warehouse data is called ETL i.e Extraction, Transformation and Loading.   You might ask why need we need to transformation? Read more ›

Categories