Error 2700 - Referential constraint violation: invalid Foreign Key value.

Applications
Applications covers the world of Teradata apps, including apps offered by Teradata (such as TRM or DCM), as well as best practices and methodologies for building your own Teradata-connected apps.
N/A

Error 2700 - Referential constraint violation: invalid Foreign Key value.

Hi ALL,

 

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.

Ex:

DIM 1 :

Primary KeyDescription
1AA
2BB
3CC

 

DIM 2 :

 

Primary KeyDescription
11X
22Y
33Z

 

DIM 3 :

 

Primary Key©Description
111A
222B
333Z
444N
555Y

 

Common table consists of below three columns and data

 

AAXA
BBYB
CCZZ

 

I have inner joined all the three Dimensions and common tbale and trying to insert into Fact tables.

 

Expected result in Fact :

 

111111
222222
333333

 

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'

 

Thanks..!

 

 

1 REPLY
Highlighted
N/A

Re: Error 2700 - Referential constraint violation: invalid Foreign Key value.

What's the DDL of the those tables? 

Are there actually FKs defined on your warehouse tables?