Description

This packaged stored procedure is used to perform the pre-validation of data in the Staging Table.

• If it is located at the OTD root level, the data in all Staging Tables is validated.

• If it is located at the Staging Table level, only the data in that specific Staging Table is validated.

Parameters

Depends upon specific implementation. By default, it contains three input VARCHAR parameters corresponding to:

• sb_eway_id

• sb_group_id

• sb_object_id

• sb_pass_or_fail

Requirements

Inside the script package, this stored procedure must have the name VALIDATE.