Set up staging validations

For each document record, you can define data validations to be done when a data record is inserted in the staging journal.

Found validation errors, warnings, or dependencies are stored as validation errors for the relevant staging journal.

For a Staging document, these standard validation classes are available:

Validation class	Description
BisValidationFieldisMantadory	This class checks if the field is filled. The arguments are: FieldValue and Type. The validation is met if the field has a valid value. For example, for date fields, the value 0 is not valid.
BisValidationReferenceExists	This class checks if a record exists in the defined table. The validation is met if at least one record exists in the table. The arguments are KeyFieldName or KeyFieldValue (only define one of these arguments) and TableName. For example, you can check if a customer exists in the CustTable. If the customer does not exist, a validation error is reported.
BisValidationMdmDifference	This class if differences exist between the data that is send from the source to the MDM staging journal and the current data in the target. This validation defines what happens with MDM staging journal lines with data differences. You can only use this class if you use: The Master data management staging journal. Data comparison on the MDM staging journal. For more information, refer to Monitor MDM staging journal.

Validation class

Description

BisValidationFieldisMantadory

This class checks if the field is filled. The arguments are: FieldValue and Type. The validation is met if the field has a valid value. For example, for date fields, the value 0 is not valid.

BisValidationReferenceExists

This class checks if a record exists in the defined table. The validation is met if at least one record exists in the table. The arguments are KeyFieldName or KeyFieldValue (only define one of these arguments) and TableName. For example, you can check if a customer exists in the CustTable. If the customer does not exist, a validation error is reported.

BisValidationMdmDifference

This class if differences exist between the data that is send from the source to the MDM staging journal and the current data in the target. This validation defines what happens with MDM staging journal lines with data differences.

You can only use this class if you use:

The Master data management staging journal.
Data comparison on the MDM staging journal.

For more information, refer to Monitor MDM staging journal.

Standard procedure

1.	Click Connectivity studio Integration Design.
2.	Click the Documents tab.
3.	In the list, find and select the desired document of type Staging.
4.	Click Edit.
5.	Click Staging display options.
6.	Click the Validation tab.
7.	Sub-task: Set up validation.
7.1	Click New.
7.2	For a Staging document, these standard validation classes are available: - BisValidationFieldisMantadory - BisValidationReferenceExists - BisValidationMdmDifference For a more detailed explanation, refer to the topic introduction. You can use a customized validation class. To do so, extend the standard validation class. If you do so, make sure to properly set the arguments.
	In the Validation class field, enter or select a value.
7.3	Choose to stop or continue the data processing if a validation is not met.
	In the Exception behavior field, select an option.
7.4	Select the type of the validation error if the validation is not met.
	In the Type field, select an option.
7.5	You can assign a unique number to the validation error message. So, you can recognize the validation error by the number.
	In the Number field, enter a number.
7.6	Define the message text for the validation error. By default, a text is given as defined in the validation class. You can change this text.
	In the Text field, type a value.
7.7	Click Save.
8.	Sub-task: Set up validation arguments.
8.1	Each validation class has several arguments to be set. For each argument, you must set either the Record field or the Constant.
	In the Record field field, enter or select a value.
8.2	In the Constant field, type a value.
9.	Activate the validation if you finished its setup and want to apply it.
	Select the Active check box.
10.	Close the page.
11.	Close the page.

Related to	Notes
Set up Staging document

Set up staging validations Application task

Standard procedure

Set up staging validations
Application task