SCD Execution on Hive Information Domain

You need to consider the following constraints and assumptions for Slow Changing Dimension (SCD) execution on Hive Infodom.