Incremental load implement

sanjeeva_279 — Sat, 16 Nov 2024 03:47:44 GMT

Hi I am trying to implement incremental load for one of my dashbaord

issues : DATE' is not a recognized built-in function name/date is not comparable with INT

i have loaded tables data in qvd and identified date field ,date field i am using it as variable max(datefield) for max date data

when i am trying to concatenate data i am having issues with date and int issues

QVD: name,date,salary ---date as field for date max(date) as maxdate

Incremental :

select name ,date,salary from table employee where date > maxdate;

concatenate

load name,date,salary from qvd;

in this scenario i am getting date issues as maxdate and date field is not compatable etc...

Re: Incremental load implement

asinha1991 — Tue, 23 Apr 2019 05:15:36 GMT

is the select query running fine?