Cairn Solutions can provide you with the skills and manpower to transform your data for one format to another, allowing you to utilise search technologies that will give you a better understanding of your companies data.
The ETL process comes in three main parts.
- The Extraction Phase
- The Transformation Phase
- The Load Phase
The Extraction Phase -- the process of taking your data in any one of the forms supplied. This can be hard copy or electronic. Obviously electronic data is preferred as this will speed up the process of preparing the data for the next phase.
The Transform Phase -- the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
The Load Phase -- the process of writing the data into the target database. ETL is used to migrate data from one database to another, to form data marts and data warehouses and also to convert databases from one format or type to another.