8 Replies Latest reply: Mar 8, 2013 1:59 AM by Muralidhar Koti RSS

    Salesforce data incremental load issue

    Muralidhar Koti

      Hi All,

       

      In my dashboard I am using the below code to incremental load Salesforce.com data. This code is taken from the demo app that is available on QlikView web site.

       

      I am not able to understand how this code handles the Accounts that get deleted within SFDC? After running the below code for 30 days, I now have a around 100 accounts in my QVD which are not in SFDC (deleted ones). I can't shift to full load as its a huge data and refresh cycle is every 30mins.

       

      Can any one had similar problems?

       

      Account_SQL:

       

       

      SQL SELECT

      *

      FROM Account

      WHERE LastModifiedDate >=
      $(vLastExecTime) and LastModifiedDate < $(vExecTime);


      // For the 1st reload, this section will be skipped.

      if Not $(FirstReload) and not isnull(QvdCreateTime('$(vQVDPath)Account_SQL.QVD'))then


      Load *

      FROM $(vQVDPath)Account_SQL.qvd (qvd)

      WHERE NOT EXISTS(Id);


      end if


      if NoOfRows('Account_SQL') > 0 then



      STORE Account_SQL INTO $(vQVDPath)Account_SQL.qvd;



      Account:

      Load

      *

      RESIDENT Account_SQL;



      DROP TABLE Account_SQL;


      End if

      Regards,

      Murali