Patent ID: 8868483
Filing Date: 2014-10-21
Classification: G06F

Abstract:
1. A method for loading customer data to a target customer database, comprising: receiving, at a processor, a plurality of data records, wherein each data record contains attribute data for at least one customer; validating, by the processor, the plurality of data records; determining, by the processor, that at least one data record lacks attribute data comprising a mandatory attribute data type; generating, by the processor, a separate warning file comprised of the at least one data record lacking the mandatory attribute data type; transforming, by the processor, the attribute data for the at least one customer to a format compatible with attribute data in the target customer database; checking the transformed data for customer addresses that match an address in the target customer database; grouping into separate files, by the processor, the transformed attribute data by an attribute data type; generating, by the processor, a key to be associated with the attribute data type for each separate file; generating, by the processor, loadable files based on the separate files and the key, for loading to the target database; partitioning, by the processor, the loadable files into a plurality of partitioned files based on the attribute type; transferring the plurality of partitioned files to the target database; and identifying any files that were partially loaded to the target database, deleting the partially loaded files from the target database by splitting the partially loaded files into separate partitions, and reloading any files that were partially loaded to the target database.