Which are the ETL Transformation?

The ETL (Extract, Transform, Load) process involves the following transformations:

1. Filtering: selecting only the relevant data from the source system.

2. Sorting: arranging the data in a specific order.

3. Joining: combining data from multiple sources based on a common attribute.

4. Aggregation: summarizing data by using measures like sum, average, count, etc.

5. Calculation: performing mathematical operations on data, such as addition, subtraction, multiplication, etc.

6. Data cleansing: correcting or removing any inaccuracies or inconsistencies in the data.

7. Data enrichment: adding additional data or attributes to the existing data.

8. Data validation: checking the data for consistency, completeness, and accuracy.

9. Data transformation: converting data from one format to another, such as converting data from text to numeric.

10. Data integration: combining data from different sources into a single dataset.

Thanks

Ajit kamble.