Question

Explain data transformation and cleaning process with the help of a suitable example.

Answer 1

Answer:

Data transformation is the process of converting data or information from one format to another, usually from the format of a source system into the required format of a new destination system.

You transform the data, such as aggregating sales data or converting date formats, editing text strings or joining rows and columns. Send the data to the target store. The target might be a database or a data warehouse that handles structured and unstructured data.

hope it helps!!