Hast anyone successfully used "Use last run datetime:" on Import Data Source

hartr
Giga Contributor

‎11-03-2011 03:51 AM

I'm trying to query a large Oracle database using the Use last run datetime: function to get incremental data. The problem I have is that if I manually populate the Last Run datetime field with "to_date('2011-11-02','yyyy-mm-dd')" then the query works (although only if I query all records, not if I specify the SQL), however the Last Run datetime field doesn't then update with the date of the latest record in the previous run as it's supposed to.

Has anyone got this feature working ? Or know what controls how the Last run datetime: field is updated ?

Thanks

0 Helpfuls
  • 4,599 Views
10 REPLIES 10

subba
Kilo Contributor

‎05-24-2012 07:57 AM

Any idea if its possible to use last run time with specific SQL queries OR is it still available only with all records option,

Thanks
Subbarao


0 Helpfuls