Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
is the select query running fine?