ETL Database

Your central database for all things ETL: advice, suggestions, and best practices

ETL Transform

Transformation refers to the cleansing and aggregation that may need to happen to data to prepare it for analysis. Architecturally speaking, there are two ways to approach ETL transformation:

In recent years, there has been a shift toward transforming data within the warehouse rather than transforming it beforehand, primarily driven by two factors:

  1. The increased performance and scalability of the modern analytics database
  2. The ability for in-database transformations to be written in SQL, the data manipulation language of choice for most analysts

Today, this approach has enough advantages that it has become the default; when projects decide to use the traditional model, this decision should come with real consideration of the costs and benefits.

ETL transformation types

Regardless of where in the process transformation takes place, it’s an important step in the analytic workflow. Transformations prepare the data for analysis. Here are some of the most common types:

Keep Learning about ETL Transformation