Limiting Dimensions

[kishorj1982]

Hi

I have 4 dimensions in dimension table and I want to limit my fact table based on the  matching combination of those Dimensions from Dimension table. How we can achieve it so that there wont be any facts without dimensions in the Fact table. Does exist clause suitable for this? As it suits in optimised load with only 1 Field I think. Please let me know.

[rwunderlich · Accepted solution]

I would use KEEP in this situation. It allows for matching on multiple columns.

-Rob

[kishorj1982]

Hi Rob Thanks for the response.

in my case if I am loading Dim Table first and then fact then I should use the Left Keep. Please confirm.

[rwunderlich]

Yes, I believe that would be a LEFT KEEP.