Hello,
I have a problem I'd like to expose you to have your opinion.
In a source table, I have a primary key composed of four columns (we will call them A, B, C and D).
D columns must be updated with a different value (a Mappin with another table)
My ODI interface, I defined the updating keys in A, B, C but of course it does not work because there is a breach of the primary key
I thought back, the first value of D in a new column (D_OLD) and use as 4th key to update.
what do you think?
Kindly suggest me the good way to do that
Thank you for your comeback