+3
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.
+1Hi 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
+3Hi 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.