| 摘要 |
An aspect of the present disclosure provides for handling of errors in data transferred from a source system to a target system. In an embodiment, the data is first transferred (from a source system) to a staging table as staging data. A user is enabled to configure rules to identify a respective portion of interest in the staging data, an error condition to be checked in the respective portion, and an action to be performed upon detection of the error in the respective portion. Accordingly, the staging data stored in the staging table is examined according to the rules to identify a first error associated with a first portion of the staging data, and an action associated with the combination of first portion and the first error is performed, as specified in the rules. |
| 主权项 |
1. A method of handling errors in data transferred from a source system to a target system, said method comprising:
maintaining in staging tables as staging data, the data being transferred from said source system to an application of said target system, wherein said staging tables are maintained as database tables accessible via a database management system (DBMS) such that said staging data is stored in said database tables; receiving rules from a user, each rule identifying a respective portion of interest in said staging data, an error condition to be checked in the respective portion and an action to be performed upon detection of an error in the respective portion based on said error condition, wherein said respective portion of interest is specified in the form of a table identifier and a column identifier, said table identifier uniquely identifying a corresponding table of said database tables, said column identifier uniquely identifying a corresponding column in the corresponding table identified by said table identifier, wherein said error condition represents the condition to be checked against each row in said corresponding column identified by said column identifier, wherein said action comprises an expression specifying a default value representing the value an entry at the intersection of said column and the row having the error, is to be set to; examining said staging data stored in said staging tables according to a first rule of said rules to identify a first error associated with a first data item in a first portion of said staging data; and performing, upon identifying said first error, an action associated with said combination of said first portion and said first error, as specified by said first rule in said rules, wherein said action updates said first data item to a new value, said new value corresponding to the default value specified by said first rule of said rules, wherein said examining and said performing of said action are performed on said staging data stored in said database tables. |
