I would like to implement "incremental refresh" for our datawarehouse database.
The logic i want to implement is :
-select max (Date_login) from LoggerETL
-select * from LoggerProduction
where Date_Login>$$max(Date_login)$$ (variable computed in first query)
I found out this approach to work but just for Strings (table row to variable) . Unfortunatly variable can be only
set to string/int values.
Any example flows which i could use with dates ?