Many data storage projects will require data to be received and adapted from various sources; each system may need to employ a separate data organisation or format and may include multiple patterns or structures. Through the transform stage, the data may be passed through a set of rules or operations to make sure it is ready for adaption at the receiving end.
At the receiving end, the process can be simple or complex depending on the needs of the application. Therefore, specialists in data handling will need to understand the range of methods used to replace old data with cumulative data. Additionally, it is vital that these IT professionals have a comprehensive understanding of data and the ETL process.
Jobs that use ETL include: