However, i notice that in the target, the update went to an incorrect record. Are we allowed to change the PKs in the transformation.? What are the implications.?
In general you can define a different key via trasformation rule as indicated in the documentation. However, you have to be aware of the consequences, as this, of course, may impact the unique key of the rows and may have impact during updates. If you would like further detailed investigation please raise a support case and provide the task diagnostic package with an example row so we can better undetstand the scenario.
In general you can define a different key via trasformation rule as indicated in the documentation. However, you have to be aware of the consequences, as this, of course, may impact the unique key of the rows and may have impact during updates. If you would like further detailed investigation please raise a support case and provide the task diagnostic package with an example row so we can better undetstand the scenario.
