This week I tried to create an incremental selection rule to load every table incremental based on the timestamp column. Except for some tables, those table needs to be fully reloaded.
An option could be to create multiple transfer tasks, but in this case, it is hard to schedule. The reload is scheduled to run every 5 minutes and it is not possible to run 2 ODX tasks at the same time.
I’ve contacted our Solution Specialist and we could not find a way to reload all tables incrementally, except a few. We tried to create multiple Incremental Load Rules, using the 'Not Contains' operator. But this operator is only exception 1 table as input. So we created multiple rules for each table that do not need to be incrementally loaded. This doesn’t work because if you create multiple rules, it is an OR instead of an AND.
I think this could be solved to add a new operator called ‘Not in list’ or ‘Not Contains in list’. Or add an option to handle multiple incremental selection rules as an AND condition, instead of an OR condition.
