When a unique key definition has been specified in HxGN SDx, Data Validator can then identify objects in the target system. You can specify the unique key for the object type and enter it in the Target System Unique Key box when you create or edit the stage object to target object mapping.
The unique key definition is specified in the same way as in HxGN SDx, but with a few changes.
-
Any properties used must be prefixed with a full stop.
-
Any environment variables must be surrounded by @ symbols
-
Any constants must be surrounded by double quotes"". Properties and relationships must be Data Validator properties and they must have an export map setup.
For example,
-
The Unique Key Definition TG,Name becomes "TG",.Name.
-
The Unique Key Definition TG,CURRENTCONFIG,Name becomes "TG",@CURRENTCONFIG@,.Name.
-
The Unique Key Definition TG,CURRENTCONFIG,+SPFTagArea.Name becomes "TG",@CURRENTCONFIG@,+SPFTagArea.Name.
-
A formatting check is performed as you enter the unique key details. A green tick indicates that the data format is correct.
-
A schema check is performed as you save the stage object to target object mapping.
-
The supported environment variables are: @CURRENTCONFIG@, @CONFIGLEVEL1@, @CONFIGLEVEL2@, @CONFIGLEVEL3@, @CONFIGLEVEL4@, and @CONFIGLEVEL5@. These variables are not case sensitive.