how to implement incremental load to a table with UNION in sql part
Hello,
my initial qvd included a UNION of two tables in the SQL part.
So for incremental load on id, i suppose I must break the tables in two and implement incremental loads on id for each one and then concatenate the tables I guess but that seems not right to me.
Or should I implement it the casual way by adding where clause after union like "where tab1.id> '$(Maxid)' and tab2.id>$(Maxid)' ?
