Cascade FOREIGN KEYS in Redshift

The guide that @christophe has written here is probably the most comprehensive docs on deduplication (both pre EMR and post EMR).