It seems that everyone has it. Ugly data. Data that isn’t so clean in transactional systems like control characters or rarely used characters that are used programmatically. This ugly data typically errors out during a load process. This requires someone to cleanse the data by writing scripts and then loading the data.
This is time consuming and feels like you are re-inventing the wheel over and over again.
Outsourcer does the cleansing for you! As the data is written to Greenplum, control characters are removed and special characters are escaped properly.
Here is a demo of Outsourcer in action loading ugly data.