9 Replies Latest reply: Jun 9, 2015 2:35 AM by Prashant Baste RSS

    Incremental Load issue

    Putturu Divya

      Hi Everyone,

       

                      I am getting error at the last line( Where Condition Load_Date>=$(VbuiMstr)),

      Any suggestions would be greatly appreciated.

      D_GIS_BUILDING_MSTR:
      LOAD COMPANY_CODE,
      OFFICE_CODE,
      CITY_CODE,
      OFFICE_NAME,
      Date(Load_Date) as Load_Date ,
      Load_DateTime
      FROM
      [..\Data Sources\Master\D_GIS_BUILDING_MSTR.qvd]
      (
      qvd);

      LET VbuiMstr=Peek('Load_Date',0,'D_GIS_BUILDING_MSTR');
      //Let Vtodayt=Today()-1;

      Incr_D_GIS_BUILDING_MSTR:
      NoConcatenate
      SQL SELECT *
      FROM HRAnt.dbo."BUILDING_MSTR" where COMPANY_CODE='C002' and Load_Date>=
      $(VbuiMstr);

       

       

      Thanks in Advance

       

       

      Regards,

      P.Divya