A system for use in loading an incoming data set into a temporal data warehouse, said system comprising: a storage device including a temporal data warehouse and an incoming data set; and a processor unit coupled to said storage device and programmed to: divide the incoming data set into a plurality of partitions including a first partition and a second partition, wherein each partition of the plurality of partitions includes a plurality of data records; import the first partition into a pre-load table; import the second partition into the pre-load table; apply the pre-load table to the temporal data warehouse; characterised in that the incoming data includes a snapshot of data from a source database, and said processor unit is further programmed to: detect that an active data record in a temporal data warehouse is not associated with a data record in the incoming data set; execute an implicit delete of the active data record based on said detecting; determine an earliest source timestamp associated with a first data record in the incoming data set; and identify a set of primary keys that represent: a data record in the temporal data warehouse associated with a source timestamp immediately prior to the earliest source timestamp; and one or more data records in the temporal data warehouse that are associated with a source timestamp later than the earliest source timestamp; and import the first partition and the second partition based on the identified set of primary keys wherein said partitions exclude all older history data records for each primary key. a storage device including a temporal data warehouse and an incoming data set; and a processor unit coupled to said storage device and programmed to: divide the incoming data set into a plurality of partitions including a first partition and a second partition, wherein each partition of the plurality of partitions includes a plurality of data records; import the first partition into a pre-load table; import the second partition into the pre-load table; apply the pre-load table to the temporal data warehouse; divide the incoming data set into a plurality of partitions including a first partition and a second partition, wherein each partition of the plurality of partitions includes a plurality of data records; import the first partition into a pre-load table; import the second partition into the pre-load table; apply the pre-load table to the temporal data warehouse; characterised in that the incoming data includes a snapshot of data from a source database, and said processor unit is further programmed to: detect that an active data record in a temporal data warehouse is not associated with a data record in the incoming data set; execute an implicit delete of the active data record based on said detecting; determine an earliest source timestamp associated with a first data record in the incoming data set; and identify a set of primary keys that represent: a data record in the temporal data warehouse associated with a source timestamp immediately prior to the earliest source timestamp; and one or more data records in the temporal data warehouse that are associated with a source timestamp later than the earliest source timestamp; and import the first partition and the second partition based on the identified set of primary keys wherein said partitions exclude all older history data records for each primary key. detect that an active data record in a temporal data warehouse is not associated with a data record in the incoming data set; execute an implicit delete of the active data record based on said detecting; determine an earliest source timestamp associated with a first data record in the incoming data set; and identify a set of primary keys that represent: a data record in the temporal data warehouse associated with a source timestamp immediately prior to the earliest source timestamp; and one or more data records in the temporal data warehouse that are associated with a source timestamp later than the earliest source timestamp; and a data record in the temporal data warehouse associated with a source timestamp immediately prior to the earliest source timestamp; and one or more data records in the temporal data warehouse that are associated with a source timestamp later than the earliest source timestamp; and import the first partition and the second partition based on the identified set of primary keys wherein said partitions exclude all older history data records for each primary key.