Incremental Load using SQL and timestamp filed in it

[alec1982]

hi all,

having some issues with SQL writing to set up incremental load using SQL and a timestamp field in it.

Best,

Alec

[JordyWegman]

Hi Alec,

You can try:

SQL SELECT (NoKey) *
FROM $(vSourceTable) // This is your source, here in a variable
where $(vIncField) I EQ '$(vIncValue)' // In this one $(vIncField) is the timestamp and $(vIncValue) is the date.
;

Best thing is to create a floored date in your SQL, like 43797, because this makes comparing easier.

Jordy

Climber