Upto 5 empty/populated tables can be loaded at a time but delete can be done from single table only. Update operator does not discard duplicate rows, it will be inserted into target table if target table is MULTISET and it will be inserted into error table if target table is SET.