delta load on last updated date

[Anonymous]

hi gurus,

LAST_UPDATE_DATE=01-01-2014 00:00:00 AM

i want lo load data >=LAST_UPDATE_DATE>=01-0102011 '00:00:00'.

its loading data for 2009,2010 ...2014.

its doing full load instead of delta

how to filter load when date as time stamp with Ante meridian,post meridian

thanks in advance

[its_anandrjs]

Hi,

Try with

Load *

From Source

Where

LAST_UPDATE_DATE >= '01-01-2011 00:00:00 AM'  and LAST_UPDATE_DATE <= '01-01-2014 00:00:00 AM';

Regards

Anand

[anbu1984]

What is your source?

[Anonymous]

oracle

[anbu1984]

LAST_UPDATE_DATE>=To_date('01-01-2011 00:00:00','MM-DD-YYYY HH:MI:SS')