Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
having some issues with SQL writing to set up incremental load using SQL and a timestamp field in it.
Best,
Alec
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