Hi, I recently created a Teradata import and configured the split colum on a date, then I enabled partition on that date and I've also enabled the "incremental load".
Now each day the job runs the import is bringing data that is equal to the "previous max split value" along with data that is greater than.
Below is an example of my where clause. The first filter is to set the start date for the first run, then the split column to enable incremental load.
WHERE t1,SNAP_DT >'2016-12-31'
and $t1.SNAP_DT$ --datameer Split Column
Am I missing something, or this is just a bug?
Please sign in to leave a comment.