Hi, I'm looking for a solution for my dimension table update : there was some changes in the data of data sources so the foreign keys of this dimension table had to be updated, but the problem is that all other colomns are updated except the foreign keys, when i check in talend job parameters (advanced settings) the colomn 'can be updated' for the foreign key attributes, i get the error below : Cannot add or update a child row: a foreign key constraint fails (`DM_AVAYA`.`DimAC`, CONSTRAINT `cible_id` FOREIGN KEY (`cible_id`) REFERENCES `DimCible` (`id_cible`) ON DELETE CASCADE ON UPDATE CASCADE) when not, the job work fine, but in both cases there is no update for foreign keys ! Any help please !
Sounds a bit confusing because a single column cannot be leaf out in a update, the record is completely updated or not (according to the update statement).
ON UPDATE CASCADE means the referencing record in the database should also be updated. It looks like some values here does not fit in these updates or violates against any other constraints.
