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, or a relationship.
Object actions
Action |
Description |
---|---|
Check Exists |
Checks to see if the object exists in the target system. |
Create Update |
Creates a new object or updates the object if it already exists 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 |
Renames the object in the target system. |
Terminate |
Terminates the object in the target system. |
Update |
Updates the object in the target system. |
Validate Only |
Validates the data 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. |
Property actions
Action |
Description |
---|---|
Check Staging File Exists |
Checks to see if the staging property file exists in the staging area. |
Check Target System File Exists |
Checks to see if 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 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 |
Terminates the property in the target system. |
Validate Only |
Validates the property 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. |
Using Data Validator, you cannot delete or terminate the required properties of an object that exists in the target system.
Relationship actions
Action |
Description |
---|---|
Check Exists |
Checks to see if 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 |
Terminates the relationship in the target system. |
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. |