The simple question is if I bring in a dimension with 200,000 items and only say 10,000 of them link to my fact table how do I get rid of the items that dont link from the model?
I am not happy with this approach myself and it is being pushed on me so
please dont say it could be done in the SQL query
please dont say do it before you import the data
I am stuck with- it must be done within the data set.
Only good thing about working remotely is they cant see you bang your head against the wall when they suggest silly ideas.
Thanks in Advance