Explain data transformation in ETL.
Data extracted from the source system needs to be cleaned, mapped and transformed before it loads into the target server.
Three steps need to be followed for data transformation:
- Selection: To select data and pack it in target
- Matching: Data matching with the target system.
- Data Transforming: Change data as per target table structures.