There has been a refresh of all the dimension tables from the production region to lower test regions to pull the latest dimension data. However, while testing, most of the referential integrity check failed. What will be the issue and how can it be handled?