We have a historic table and we use Dw_id as an unique indentifier.
But when we update the record the DW_Id will stay the same, so we have duplicate values in the table on that field then. the original DW_id field is changing but the transformantion field isn’t.
Because we work with custom data aswell that we want to have there own value we work with the custom transformation. I will provide some screens from the issue:
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/01aa020b-0d3e-46df-aaaa-53946a3b5f58.png)
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/c9ba723d-a6ca-4419-bc1e-fcd009072835.png)
![](https://uploads-eu-west-1.insided.com/timextender-en/attachment/8bc51921-6a93-41f1-878b-d52424668399.png)
Can you provide me a way so the field eenheidssleutel will be unique over time and is equal to the DW_ID now and in the past of the historic table.
Best answer by Christian Hauggaard
View original