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:
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 HauggaardView original