CIMA E1 Syllabus C. Data And The Finance Function - ETL - Notes ^{2 / 8}

ETL

ETL systems pull data from one source or a multiple source database, process it and then place it into a new destination. It enables compatibility throughout all departments to facilitate efficient operations and reporting capabilities.

Three main stages of ETL:

1. Extraction

   Data is typically pulled from multiple source databases.

   Data profiling takes place before 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 held in a systematic and logical way, it can be analysed and business intelligence can be created from it.