Order Management Interface
HI 2 All,
A quick question/doubt from my side. what is need of validating the staging table data when the oracle standard concurrent program takes care of validating the data. Generally the oracle standard concurrent program picks the error records and then inserts into the error tables . IN Open interface table approach first we load the flat file data into the staging table and then by validating the staging table we will insert into the interface tables. why should we do some validations before inserting the staging table data into the interface tables.why it is mandatory to validate the data before loading