In SDE layer, Fact Stage and Dimention stage tables are populated with out the references of each other. In other words, while loading a Fact stage table actual value of Dimension gets stored. In SIL layer, dimension would be inserted first and then fact would insert so that actual dimensional value in fact gets stored as…