I am facing the the above referential integrity error and tried a lot to trouble shoot but unfortunately couldnot do it.
Problem Statement: Facing Error 2700 - Referential constraint violation: invalid Foreign Key value.
I have three dimension Tables and a Fact table.
Three Dimensions have three primary keys and Facts has forien keys.
DIM 1 :
DIM 2 :
DIM 3 :
Common table consists of below three columns and data
I have inner joined all the three Dimensions and common tbale and trying to insert into Fact tables.
Expected result in Fact :
But I am not sure why I getting the error Error 2700 - Referential constraint violation: invalid Foreign Key value.
Can Anyone help me in this?
Note - I have updated the DIM 3 with Primary Key 222 from 'F' to 'B'
What's the DDL of the those tables?
Are there actually FKs defined on your warehouse tables?