Icon

02.1_​Data_​Anonymization

02.1_Data_Anonymization_solution

The company has two branches: one in the United States and another one in Europe. New US customer data comes from a web service. New Europe customer data comes from Amazon S3.

We access, validate, prepare, and blend the data, anonymize it, and insert it to the database table "customers". We export the final status of the workflow. In the case some processes fail, we notify responsible people via an automated email.


Extract Transform Load Session 2 ETL Processing IIExercise 02.1 Data Anonymization 3 DataAnonymizationOpen the component to findthe instructions ExercisesAll the tasks can be found in the yellow annotations and the yellow components.Make sure you have executed the 00_Setup_PostgreSQL_Database workflow before running this workflow. Blend the data fromdifferent sourcesExecute up-streambefore configuration Concatenate Data Anonymization Data AccessEurope Customers Data AccessUS Customers Extract Transform Load Session 2 ETL Processing IIExercise 02.1 Data Anonymization 3 DataAnonymizationOpen the component to findthe instructions ExercisesAll the tasks can be found in the yellow annotations and the yellow components.Make sure you have executed the 00_Setup_PostgreSQL_Database workflow before running this workflow. Blend the data fromdifferent sourcesExecute up-streambefore configuration Concatenate Data Anonymization Data AccessEurope Customers Data AccessUS Customers

Nodes

Extensions

Links