During ETL, loading Facts we always do a lookup with the dimensions to ensure that data gets filtered. In other words fact tables will contain only that data whose reference is present in dimension tables. Adding primary key foreign key relationship will decrease the response time