JDBC Producer not updating the table if the table has composite primary key

Hi Ankur,

We do support changes in tables with composite primary key. Only latest versions support change in primary key itself. Is this the case? Can you explain which SDC version are you using?

Best!

Dimas

Hi @Dimas Cabré i Chacón,

I think 5.3.0 as below:

Hi @Dimas Cabré i Chacón 

Does the version 5.3.0 support composite key update?

Hi Ankur. Yes.

Hi @Dimas Cabré i Chacón ,

But it is not working.

Below is the case:

There are two source tables (in actual we have six source tables):

Table1:

Columns: Col1, Col2, Col3

Primary Key: Col1

Table2:

Columns: Col1, Col2, Col3, Col4

Primary Key: Col1

There is one target table:

Target:

Columns: Tab1_col1, Tab1_col2, Tab1_col3, Tab2_col1, Tab2_col2, Tab2_col3, Tab2_col4

Primary Key: Tab1_col1, Tab2_col1

If I am updating Table 1 suppose Col3 

Then in Target table Tab1_col3 is not getting updated automatically.

Please look into it and suggest.

Hi @Ankur . Primary key support is based on table to table mapping. Your scenario is joining tables and it is not an standard use case . We do not support this from scratch.

Best!