ETL ELT Stream ; How we should handle?

Posted on by gurvinder

ETL is used by the Data Engineers, ETL or ELT Developers and involves the learning process for various tools and the architecture’s used. With the emergence of the big data and different formats , the ETL process used for data migration becomes sometimes complex. The purpose of this web site is to discuss various scenarios based on the Architecture , Tools used , Performance, Level of effort involved in development and

Data Migration Scenarios

  1. Migration of Data for Data Warehouses
  2. Migration of Data for Application Upgrades
  3. Migration of Data for New Applications
  4. Migration of Data for Data Analytics

The above scenarios , just came in my mind , there can be many other reasons for the organization to migrate and transform the data.

Misconception’s

First misconception and the most common is to determine the scope of the migration project. Data Migration is a backend process.

Tools and Languages

There are various tools available in the market by Microsoft, Informatica, Data Bricks, Oracle are the few that come in my mind and are mostly used across different industries.