Cleansing data

After profiling customer data and identifying its problems, some actions should be taken on data to cleans it. You may start by generating two Talend Jobs: one to remove duplicates from the email column and the other to remove the values that do not match the email pattern.

This will help you see what to resolve and then you can decide what tool to use to intervene and resolve these address issues.