ETL

NotesQuizObjective TestMock

What is ETL?

ETL

ETL systems pull data from one source or a multiple source database, process it and then place it into a new destination. 

Three main stages of ETL:

  1. Extraction

    Data is typically pulled from multiple source databases.

    Data profiling is part of the extraction stage and ensures that the source data is validated. 


    Data profiling can also be explained as analysing data to understand its content, structure and format before transferring it from its source to its warehouse.

  2. Transformation

    Data is transformed into a format that is suitable for us. Codes are used in this stage to convert source data to a new format.

  3. Loading

    This newly created data in the required format will be uploaded into the new data store. 

    Typically, this is a data warehouse, where it can be analysed and business intelligence can be created from it.

NotesQuizObjective TestMock