In this method, the fields from one of the tables are removed and it won’t be loaded at all. Consider the following case where the sales table and the product table are linked together thus generating the synthetic key, as shown in the following image:

As you can see, there are two fields that are common across both the tables. They are product and product category. Looking at the data, we can remove the field product category from the sales table because the least granularity field product is available in sales table. Hence removing product category from sales table will not have any impact.

The script and the data model, after removing the field, look as follows: