Beginners Guide for Creating an IBM Infoshere MDM External Validation

External validation is the ability of MDM  to validate end user data before updating or adding transactions.IT determines the data being entered is a valid or invalid one. External validation are triggered at the pre of the controller.

There are 2 main categories of external validation

1)Field Level(Element Level)

2)Cross Filed Level(Group Level)

It will elaborate more on field level validation here.The element level validation is generally used under the following circumstances.

• To check whether the field is optional or mandatory.
• To specify minimum and maximum field lengths and values.
• To specify allowable and prohibited values and patterns etc.

The tables involved are :

1)V_ELEMENT

2)V_ELEMENT_VAL

3)V_ELEMENT_PARAM

4)V_FUNCTION

The V_ELEMENT contains the attribute which needs to validated.

V_ELEMENT_VAL relates the attribute(element) with the validation function.

V_ELEMENT_PARAM can be used to specify the param type and the param value.The param type is used to retrieve the param value in the validation function we write.

V_FUNCTION contains the fully qualified class path to the validation function class.(Function name , Java class).