Skip to main content
To homepage To homepage

I’ve some tables in my data source without primary key, but I’ve a MODIFIEDDATETIME field for all the records, that it can be used to incremental load, but TX doesn’t allow it.

Some workaround?

 

Dear rvgfox,

You can setup a Primary Key Rule in the ODX per connector or define (by hand per table per datasource) for each table the PK and take it from there.

Hope this helps

Thanks @daniel I know that, but my question it’s define incremental load whithout PK.

Obviously it assumes that existing records will never be updated.

Dear rvgfox,

As far as I know this is not yet the case. I know that this idea has been pitched to TX and the R&D team, but i'm not sure if or when it will be on the road map.

Hi Ramon

You can run incremental load without PKs if you do not use updates and deletes.

It can give issues in the data area though as there is no checks for double rows.

Reply


Terms and ConditionsCookie settings