摘要 |
PURPOSE: A standardized source loading program generating method, a system for the same, a recording media, and a data loading method using the method are provided to selectively load a data warehouse to data extracted from a source system. CONSTITUTION: Data is extracted from the database of a source system(S10). A noble source loading program is generated using an SQL sentence through mapping definition for the extracted data(S20). Based on the noble source loading program, whether the extracted data from the database of the source system is error data is verified(S30). The extracted data is loaded in a data warehouse(S50).
|