0 Replies Latest reply: Oct 20, 2015 12:46 PM by kumar avisakula RSS

    Issue in incremental load script

    kumar avisakula

      Hello experts,

       

      I am getting below in my test environment and it is working in Dev.

       

      Inserts:

      LOAD *

      FROM

      $(Vqvxpath)dim_account_inserts.qvx(qvx);

       

      date_dim_account:

      LOAD Max(account_record_updated_datetime) as dim_account_Maxdate

      Resident Inserts;

       

      LET VDate_dim_account = Peek('dim_account_Maxdate',0,'date_dim_account');

       

      DROP Table date_dim_account;

       

      STORE Inserts into $(Vqvdpath)dim_account.QVD(qvd);

      DROP Table Inserts;

       

      Updates:

      LOAD *

      FROM

      $(Vqvxpath)dim_account_updates.qvx(qvx)

      Where (account_record_updated_datetime >'$(VDate_dim_account)') ;

       

      Concatenate

      LOAD *

      FROM

      $(Vqvdpath)dim_account.qvd(qvd)

      Where not Exists(account_key);

       

      STORE Updates into $(Vqvdpath)dim_account.QVD(qvd);

         

      DROP Table Updates;

       

       

       

      Can anybody help me this one.

       

      Regards,

      kumar