I have a source database that allows NULL values in primary key columns. What happens now is that these tables fail on transfer because the ODX server does not allow NULL values in key columns.
I can of course override the key for the table but it is a key provided by the source database, and this also eliminates the possibility to set up an incremental load.
Also, my general incremental load rule (this database has a change date column with the same name in every table) leads to a warning every time the table with the removed primary key columns is transferred.
A solution would be to set an option to allow NULL values in primary key columns, or to be able to set a default value on columns.
