7 Replies Latest reply: Jan 28, 2015 2:41 AM by jagan mohan rao appala RSS

    Can't we use Where Class to QVD file while reading data from QVD file

    Shivendoo Kumar

      Hi Guys,

       

      I was trying for Incremental load and so written below query:

       

      FACT_DATA:

      LOAD

      * FROM [D:\FACT_DATA.QVD](QVD)

      WHERE (DATE_KEY<$(V_FROM_DATE_KEY) AND DATE_KEY>$(V_TO_DATE_KEY))

       

      But It is not loading any data even-though I have data to [D:\FACT_DATA.QVD](QVD) and also not throwing any error.