Incremental load implement

[sanjeeva_279]

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...

[asinha1991]

is the select query running fine?