Solved

Incremental load without primary key

  • 9 March 2023
  • 4 replies
  • 240 views

Userlevel 4
Badge +1

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?

 

icon

Best answer by Thomas Lind 10 March 2023, 10:30

View original

4 replies

Userlevel 4
Badge +5

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

Userlevel 4
Badge +1

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.

Userlevel 4
Badge +5

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.

Userlevel 6
Badge +5

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