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

    Where exists clause in script

    nicolai Stæger-Holst

      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.

       

      Nicolai