Reasons to Denormalize Using Prejoins
The following items are all possible reasons for denormalizing with prejoins:
Performance can be enhanced significantly.
The method is a good way to handle situations where there are tables having fewer
rows than there are AMPs in the configuration.
The minor entity is retained in the prejoin so anomalies are avoided and data consistency