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.
BY Best Interview Question ON 26 Jan 2019