Hi @srinivas1921 ,
If I understand you correctly, you want to associate your dimension table with your fact table anywhere CD_Loc is equal to either END_Loc1 or END_Loc2. Is that correct?
If so I believe you can concatenate the table twice and duplicate records to do this (please be careful when aggregating on this table). You can do this by trying something like this.
End_Loc2 as End_Loc1,
I hope this makes sense, please let me know if I've misunderstood your question.