4 Replies Latest reply: Jul 7, 2016 1:23 AM by nicolai Stæger-Holst RSS

    Where exists clause in script

      Hi there,


      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 ...;


      LOAD *;

      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?


      Thank you in advance.