Currently I have two scripts, one containing fact-tables and the second containing relevant dimensions of these facts. In my fact-script I have made a where clause that filters out observations that is not relevant. Therefore I would to perform a where exists load on my dimensions, in order to not just load every single dimension value. Currently I have tried the following syntax:
LIB CONNECT TO ...;
SQL SELECT *
FROM EDW.qs.vDimCustomerSellTo where exists (vDimCustomerSellto);
I only want to load CustomerSellTo-values that are represented in my fact-tables.
All my fact-tables are loaded correct, however the statement above does not seem to work for me, does any of you know why?