In the advanced options at the end of the job wizard, there is an option to direct DTM to a source field with a last change timestamp. My understanding is that this will prompt DTM to only process records that have changed since the last time the DTM job was run rather than process all records from the source.
I have a source field with last change date of m/d/yyyy (i.e. 4/18/2008). I've pointed DTM to this source field (using Excel as a source for testing but it will be Oracle in production), but this option doesn't seem to be working for me. Is the time format m/d/yyyy supported by this feature? What time formats are supported?