Skip to main content

 

Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"),key ('20860378'), rows 11 and 12. Table "B": key column ("E"), key ('2967401'), rows 1755584 and 1952229.

Hi Richa,

 

Not sure how you are joining the table, but based on cardinality, one table should not have duplicate records.... in your example Table A and Table B both have duplicate records. Based on key columns it should be 1:N or N:1 relationships in cardinality.

 

Regards

Muthappan


Hi Richa,

 

Not sure how you are joining the table, but based on cardinality, one table should not have duplicate records.... in your example Table A and Table B both have duplicate records. Based on key columns it should be 1:N or N:1 relationships in cardinality.

 

Regards

Muthappan

Thanks @muthappan.alaga , It's been fixed now.


Reply