Must both source and target fields be the same in order to map correctly the data to update? The system allowed me to select the source kf fields for mapping.
I mapped in update rule, a source field different from target field and the effect was that :
Source is ODS. Target is Cube.
ABC 100 200
ABC 100 999
DEF 101 300
DEF 100 999
As you can see, the second record was not updated as it should. In fact same as record1. The update is addition for all KFs.
Any advise would be appreciated.