Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental load, with seperate lastdate and lasttime fields

Howdy, i'm having trouble building my incremental data load because my "last modification field" is actually a seperate date and time field..

LASTTIME,

LASTDATE

How do i go about handling this? It's not letting me do..

Where TIMESTAMP(LASTDATE,LASTTIME) >= #$(LastExecTime)#

and      TIMESTAMP(LASTDATE,LASTTIME) < #$(ThisExecTime)#;

1 Reply
Not applicable
Author

Please...any ideas?