image
Welcome We are an independent IT company with offices in Scotland and Northern Ireland.

Our simple goal is to provide services that help you meet your IT objectives in a professional and cost effective way. We are large enough to handle all your IT needs but small enough to care

Our distinct service divisions can provide you the specialist services required in "Server & Environment Maintenance", "Infrastructure Design & Implementation" and more specialist Software Application Development & Integration"

ETL Services

Extract, Transform & LoadCairn 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.