When you define a column header in Data Validator, you assign it an action. This action indicates what Data Validator will do with the data imported from the related column in the CSV file. The kinds of operations supported varies, depending on whether the column header is mapped to an object, a property, relationship, or relationship property.
The list of actions available for a property or a relationship is determined by the action selected for the object. For more information, see Export mapping actions.
Data Validator supports the following object actions:
Action |
Description |
---|---|
Check Exists |
Checks that the object exists in the target system. |
Create Update |
Creates a new object and updates the existing object in the target system. |
Delete |
Deletes an object in the target system. |
No Action |
No action is taken on the object in the target system. |
Rename |
The object is renamed in the target system. |
Terminate |
The object is terminated in the target system. |
Update |
The object is updated in the target system. |
Validate Only |
No action is taken on the object in the target system, but if errors are found then they are propagated to the related objects. |
Data Validator supports the following property actions:
Action |
Description |
---|---|
Check Staging File Exists |
Checks that the staging property file exists in the staging area. |
Check Target System File Exists |
Checks that the target system property exists in the target system. |
Compare Create |
Invokes the compare value rule, which creates an error if the target system value is different. The target system property is only overwritten if the value is not set. |
Compare Value |
Invokes the compare value rule, which never changes the value in the target system. |
Create Update |
Creates a new property and updates the existing property in the target system. |
Delete |
Deletes a property in the target system. |
No Action |
No action is taken on the property in the target system. |
Terminate |
The property is terminated in the target system. |
Validate Only |
No action is taken on the property in the target system, but if errors are found then they are propagated to the related objects. |
Using Data Validator, you cannot delete or terminate the required properties of an object that exists in the target system.
Data Validator supports the following relationship actions:
Action |
Description |
---|---|
Check Exists |
Checks that the relationship exists in the target system. |
Create Update |
Creates a new relationship and updates the existing relationship in the target system. |
Delete |
Deletes a relationship in the target system. |
No Action |
No action is taken on the relationship in the target system. |
Terminate |
The relationship is terminated in the target system. |
Data Validator supports the following relationship property actions:
Action |
Description |
---|---|
Create Update |
Creates a new relationship property and updates the existing relationship property in the target system. |
No Action |
No action is taken on the relationship property in the target system. |
Compare Create |
Invokes the compare value rule, which creates an error if the target system value is different. The target system relationship property is only overwritten if the value is not set. |
Compare Value |
Invokes the compare value rule, which never changes the value in the target system. |